SiteMap  | About    

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.
  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.



<?xml version="1.0"?>
	<add name="SQLDbConnection"
		 connectionString="Server=servername; Database=pubs; User Id=username; password=password"
		 providerName="System.Data.SqlClient" />

You have to fill appropriate web.config database parameters



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head id="Head1" runat="server">
	<title>Untitled Page</title>
	<form id="form1" runat="server">
		<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
	<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

Click the following links to see full source code

C# Source Code
VB.NET Source Code
default.aspx.vb (C) 2015    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.