I still can't figure out .net 2.0 DB Connection Strings

[Darrel]

*sigh*...I have gotten no where with my .net 2.0 project. ;o)

I'm still stuck on db connection strings.

I have a connection string in my web config:

<appSettings>
<add key="DBConn" value="[my connection string]" />
</appSettings>

Then in my function, I try to get it. I've tried this:

Dim strConnect As String =
ConfigurationManager.ConnectionStrings("DBConn").C onnectionString()

as well as this:

Dim strConnect As String =
ConfigurationManager.ConnectionStrings("DBConn").t oString()

to no avail.I keep getting an error on that line:

--------------
Object reference not set to an instance of an object.
App_Web_0-ola1a7
--------------

What am I doing wrong?

-Darrel

[Marc Scheuner]

>*sigh*...I have gotten no where with my .net 2.0 project. ;o)

I'm still stuck on db connection strings.

I have a connection string in my web config:

<appSettings>
<add key="DBConn" value="[my connection string]" />
</appSettings>

Then in my function, I try to get it. I've tried this:

Dim strConnect As String =
ConfigurationManager.ConnectionStrings("DBConn"). ConnectionString()

You need to put your connection strings into the <connectionStrings>
section - *NOT* the <appSettings> !

Marc

[William Buchanan]

<configuration>
<appSettings>
<add key="XXX" value="YYY" />
</appSettings>
<connectionStrings>
<add name="MyConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=MyData.mdf;In tegrated
Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
......

"Darrel" <no*****@nospam.com> wrote in message
news:eQ**************@TK2MSFTNGP04.phx.gbl...

*sigh*...I have gotten no where with my .net 2.0 project. ;o)

I'm still stuck on db connection strings.

I have a connection string in my web config:

<appSettings>
<add key="DBConn" value="[my connection string]" />
</appSettings>

Then in my function, I try to get it. I've tried this:

Dim strConnect As String =
ConfigurationManager.ConnectionStrings("DBConn").C onnectionString()

as well as this:

Dim strConnect As String =
ConfigurationManager.ConnectionStrings("DBConn").t oString()

to no avail.I keep getting an error on that line:

--------------
Object reference not set to an instance of an object.
App_Web_0-ola1a7
--------------

What am I doing wrong?

-Darrel

[Chris Fulstow]

Hi Darrel,

For web applications, the preferred way to work with configuration file
is to use the new .NET 2.0 WebConfigurationManager class, rather than
ConfigurationManager. For example:

Dim strConnect As String =
WebConfigurationManager.ConnectionStrings("Connect ionStringName").ConnectionString

More info on MSDN:
http://msdn2.microsoft.com/en-us/lib...er(VS.80).aspx

HTH,

Chris

[Darrel]

<configuration>
<appSettings>
<add key="XXX" value="YYY" />
</appSettings>
<connectionStrings>
<add name="MyConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=MyData.mdf;In tegrated
Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>

THanks, william...that clarified things!

-Darrel

[Darrel]

You need to put your connection strings into the <connectionStrings>
section - *NOT* the <appSettings> !

Aha! Thanks, Marc...that was staring right at me in the config file, too.
'doh!

-Darrel

[Darrel]

Dim strConnect As String =
WebConfigurationManager.ConnectionStrings("Connect ionStringName").ConnectionString

More info on MSDN:
http://msdn2.microsoft.com/en-us/lib...er(VS.80).aspx

Thanks, Chris!

-Darrel