This will be Helpful to u.
First use the Namespaces
using System.Data.SqlClient;
using System.Web.Configuration;
public partial class Default : System.Web.UI.Page
{
private static readonly string _connString = String.Empty;
SqlConnection con = new SqlConnection(_connString);
static Default()
{
_connString = WebConfigurationManager.ConnectionStrings["DataBaseNameConnectionString"].ConnectionString;
}
}
and this code in WEB.Config File
<connectionStrings>
<add name="DataBaseNameConnectionString" connectionString="Data Source=system name or Server name;Initial Catalog=DataBaseName;user id=sa;password=123" providerName="System.Data.SqlClient"" />
</connectionStrings>