Web.Config - retrieving DB connection strings held in specific section

[Griff]

Hi

Bit confused about how to read a connection string from my web.config...I
need to hold this data in a particular section (v2.0 specific).

Extract from web.config:
-------------------------------------
<configuration>

<configSections>
<sectionGroup name="OurCompanyName">
<section name="OurApplicationName"
type="System.Configuration.NameValueSectionHandler "/>
</sectionGroup>
</configSections>

<OurCompanyName>
<OurApplicationName>
<add
name="OurDatabaseName"
connectionString="Server=localhost;User
ID=xxxx;Password=xxxx;Database=xxxx;Persist Security Info=True;async=true"
providerName="System.Data.SqlClient" />
</OurApplicationName>
</OurCompanyName>
......
<appSettings/>
<connectionStrings/>
<system.web/>
</configuration>
-------------------------------------

I just can't get the code right for extracting this information....

Many thanks in advance

Griff

[Gaurav Vaish \(www.EdujiniOnline.com\)]

I just can't get the code right for extracting this information....

What is that you didn't get write?
Handler? Are you looking at 1.1?

In 2.0, look into ConfigurationSection and ConfigurationElement in
System.Configuration namespace.
--
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujinionline.com
http://eduzine.edujinionline.com
-----------------------------------------

[Juan T. Llibre]

Karl Seguin has a very good tutorial on custom configuration sections at :

http://openmymind.net/Configuration/index.html

It'll help you do what you want to do.


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Griff" <ho*****@the.moonwrote in message news:O4**************@TK2MSFTNGP02.phx.gbl...

Hi

Bit confused about how to read a connection string from my web.config...I need to hold this data
in a particular section (v2.0 specific).

Extract from web.config:
-------------------------------------
<configuration>

<configSections>
<sectionGroup name="OurCompanyName">
<section name="OurApplicationName" type="System.Configuration.NameValueSectionHandler "/>
</sectionGroup>
</configSections>

<OurCompanyName>
<OurApplicationName>
<add
name="OurDatabaseName"
connectionString="Server=localhost;User ID=xxxx;Password=xxxx;Database=xxxx;Persist
Security Info=True;async=true"
providerName="System.Data.SqlClient" />
</OurApplicationName>
</OurCompanyName>
.....
<appSettings/>
<connectionStrings/>
<system.web/>
</configuration>
-------------------------------------

I just can't get the code right for extracting this information....

Many thanks in advance

Griff