Setting up connection string in ASP.NET to SQL SERVER WEB.config Global

Posted by: Vishal Kottarathil on 8:48 AM in .Net, ASP, SQL SERVER 0

In Web.config under <configuration> Tag

<connectionStrings>
    <add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>

in C# code usage

  SqlCommand command;
        public static string connectionstring = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ToString();
        SqlConnection conn = new SqlConnection(connectionstring); 

Dont Forget to add "using System.Configuration;"