ASP.NET Sql Server Connection
The SqlConnection Object is Handling the part of physical communication between the ASP.NET application and the SQL Server Database . An instance of the SqlConnection class in ASP.NET is supported the Data Provider for SQL Server Database.vb.net
Dim connectionString As String
connectionString = ConfigurationManager.ConnectionStrings("SQLDbConnection").ToString
string connectionString = ConfigurationManager.ConnectionStrings["SQLDbConnection"].ToString();
When the connection is established , SQL Commands will execute with the help of the Command Object and retrieve or manipulate the data in the database. Once the Database activities is over , Connection should be closed and release the Data Source resources .
The Close() method in SqlConnection Class is used to close the Database Connection. The Close method rolls back any pending transactions and releases the Connection from the SQL Server Database.
The following ASP.NET program connect to a database server and display the message in the Label control.
You have to fill appropriate web.config database parameters
Click the following links to see full source code