Connect With Sql Server

Web Config



<appSettings>
    <add key ="ConnectDB" value ="Data Source=xxxxxx;Initial Catalog=xxxxxxxx;User ID=xxxxxxxxxxx;Password=xxxxxxxxxx"/>
   
  </appSettings>











DLL CLASS



 public class ClsDB
    {

        SqlConnection Con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectDB"]);
        public void DoConnection()
        {
            if ((Con.State == ConnectionState.Closed) || (Con.State == ConnectionState.Broken))
            {
                Con.Open();
            }
        }
}