how to give connection in web config file ?

Question

since we give connection in aspx.cs file we want to give connection in web config file .how to give connection.

Answer 1

Do you mean connection string?

If so then what I do is have my web.config file like this;

<connectionStrings configSource="ConnectionStrings.config" />

And then I have a connectionstrings.config file;

<connectionStrings>
    <add name="Production" connectionString="Data Source=MYDS; Initial Catalog=InitCat; User ID=UID; Password='Password';"
      providerName="System.Data.SqlClient" />
    <add name="PreProduction" connectionString="Data Source=MYDS; Initial Catalog=InitCat; User ID=UID; Password='Password';"
      providerName="System.Data.SqlClient" />
    <add name="Development" connectionString="Data Source=MYDS; Initial Catalog=InitCat; User ID=UID; Password='Password';"
      providerName="System.Data.SqlClient" />
</connectionStrings>

Then, based on a flag, I load the relevant connection string using;

System.Configuration.ConfigurationManager.ConnectionStrings["PrePorduction"].ConnectionString

Answer 2

You can use the ConnectionStrings element in the Configuration settings. If you want to know the specific format for different providers and various options that can be specified in the connection string property have a look at connectionstrings.com