Web.config file write connection string to access all web pages for same application - ADO.NET

Discussion

• Digvijay   -Posted on 20 Oct 15
  If you write connection string in web.config file, then you can access it in all the web pages for the same application.
  I have written my connection string in web.config file as follows. You can edit the connection string according to your computer and server setting.
  <connectionStrings>
  
  <add name="connString" connectionString="data source=(local);initial
  catalog=Employee;integrated security=true"/>
  
  </connectionStrings>
  
  You can access this connection string in cs file as follows.
  string con= ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
  
  SqlConnection conObj = new SqlConnection(con);
  conObj.Open();
  
  --------
  --------
  conObj.Close();
  

➨ Post your comment / Share knowledge