ASP.Net C# Database Connection

by top54u.com 07 Feb, 2008

Inside ASP .NET Tutorials

ASP.Net C# access database

ASP.Net 2.0 Access Database connection string

ASP.Net 2.0 SQL Server database connection string

ASP.Net Access Database Connection

Managing Database connection in ASP.Net

Connection Pooling In ASP.Net

Database Connectivity in ASP.Net

Spotlight.....

ASP.Net Web.config settings to define connection string for C# Database Connection:
Add the following string in <configuration> section of web.config file:

In the value attribute:

Data Source:
You can use the IP address of the web server configured with SQL server or where you have hosted your web site. Mostly in Data Source field localhost is used.

Initial Catalog:
Enter the name of the SQL Database.

User ID and Password:
Enter the MS SQL Server authenticated username and password.

Import Namespaces for SQL Connection:

using System.Data;
using System.Data.SqlClient;

C# Code to access the database connection:

// string variable to store the connection string
// defined in appsettings section of web.config file.
string connStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();

// object created for SqlConnection Class.
SqlConnection mySQLconnection = new SqlConnection(connStr);

// if condition that can be used to check the sql connection
// whether it is already open or not.
if (mySQLconnection.State == ConnectionState.Closed)
{
mySQLconnection.Open();
}

// message string just to display the sql connection state.
Response.Write("ASP.Net 2.0 SQL Database Connection State: <b>" + mySQLconnection.State + "</b>");

// if condition that can be used to check the sql connection
// if it is open then close it.
if (mySQLconnection.State == ConnectionState.Open)
{
mySQLconnection.Close();
}