ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. Connection tester
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"  Inherits="TestConnection" %>



   Testing the Connection


   
      
         

Testing the Connection


         
         This example tests the Connection class.
         
         
         
      

   


File: Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Web.Configuration;
public partial class TestConnection : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
      SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
      builder.DataSource = "localhost";
      builder.InitialCatalog = "Northwind";
      builder.IntegratedSecurity = true;
      string connString = builder.ConnectionString;
      SqlConnection conn = null;
      try
      {
         conn = new SqlConnection(connString);
         conn.Open();
         labMsg.Text = "State of Connection: " + conn.State;
      }
      catch (Exception ex)
      {
         labMsg.Text = "Error occurred accessing the database";
         labMsg.Text += "
" + ex.Message;
      }
      finally
      {
         if (conn != null)
            conn.Close();
      }
   }
}