Home About Us SQL Interview Book Contact Us RSS
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar


Storing Connection String Information in Web.Config 

You can store the connecting string information in your web.config file in two ways:

  •  Using <appSettings> Section
  •  Using <CustomSection> Section.

Using <appSettings> Section

The predefined <appSettings> section can be placed in any web.config file or the machine.config file. This section is useful for storing name-value pairs of data. An example of the use of the <appSettings> section is as follows,

<appSettings>
       <add key="ConnectionString" Value="myconnectionstring" /> 
</appSettings>

To access the appSettings Value, you need to use ConfiugrationSttings.AppSetting["ConnectionString"]. This uses the NameValueFileSectionHandler, which returns a System.Collection.Specialized.NameValueCollection object. The collection implements the IEnumerable interface so you can enumerate the collection, or read values directly for any valid key.

For more details accessing appSetting value refer this link, 
Accessing the appSettings Section

Using <CustomSection> Section

You can create your own custom sections in a configuration file. The easiest way to do this is to configure one of the pre-existing configuration section handlers, assuming your section uses one of the generic structures such as name-value data, or single tag data. In this particular case you might use the Name-Value data. To do this, you need to use the pre-defined section handlers.

 For example, you can define a section called , <myNameValueSection>

<myNameValueSection>
         <add key="ConnectionString" Value="my connection string"
<myNameValueSection>

To read the data, you will need the following code snippet ,

NameValuecollection config = ConfigurationSettings.GetConfig("myNameValueSection")

For each key in config.keys
       label1.Text = "Key:" + key.toString()
       label2.Text = "Value:" + config[key]
End Loop