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").ConnectionString()

as well as this:

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

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

 

[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;Integrated
Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
......

 

[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("ConnectionStringName").ConnectionString

More info on MSDN:
http://msdn2.microsoft.com/en-us/li...iguration.webconfigurationmanager(VS.80).aspx

HTH,

Chris

 

[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]

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

THanks, william...that clarified things!

-Darrel

 

[Darrel]

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

More info on MSDN:
http://msdn2.microsoft.com/en-us/li...iguration.webconfigurationmanager(VS.80).aspx

Thanks, Chris!

-Darrel