ASP.NET Connection String
A connection string provides the information that a
provider needs to communicate with a particular database. The Connection
String includes parameters such as the name of the driver, Server name
and Database name , as well as security information such as user name
and password.
An ADO.NET Data Provider is a class that can
communicate with a specific type of database or data store. Usually Data
Providers use a connection string containing a collection of parameters
to establish the connection with the database through applications. The
.NET Framework provides mainly three data providers, they are
Microsoft SQL Server
OLEDB
ODBC
Here you can see how to make a connection string to the following ADO.NET Data Providers.
Microsoft SQL Server Connection String
connetionString="Data Source=ServerName;Initial Catalog=Databasename;
User ID=UserName;Password=Password";
OLEDB Data Provider Connection String
connetionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdatabasename.mdb;"
ODBC Connection String
connetionString="Driver={Microsoft Access Driver (*.mdb)};DBQ=yourdatabasename.mdb;"
You have to provide the necessary connection information to the Connection String attributes
Web.config and ConnectionString
You can store connection strings in the Web.config
file and reference the configuration entries in data source controls.
You can create connectionStrings element within the Element element, by create a child element named and place your connection strings there.
<configuration>
<connectionStrings>
<add name="RamaConnectionString"
connectionString="Server=Rama-PC; Database=Test; User Id=sa; password= Admin123"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
You can access the connectionstring value at run time in your ASP.NET application as shown in the following example.
C#
string conn = ConfigurationManager.ConnectionStrings["RamaConnectionString"].ToString();
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.
C#
string conn = ConfigurationManager.ConnectionStrings["RamaConnectionString"].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.
web.config
<?xml version="1.0"?>
<configuration> <connectionStrings>
<add name="RamaConnectionString"
connectionString="Server=Rama-PC; Database=Test; User Id=sa; password= Admin123"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
You have to fill appropriate web.config database parameters
Default.aspx
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
</div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</form>
</body>
</html>
default.aspx.cs
using System;
using System.Data ;
using System.Data.SqlClient ;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
protected void Button1_Click(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["RamaConnectionString"].ToString();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
Label1.Text = "Connected to Database Server !!";
connection.Close();
}
}
No comments:
Post a Comment