Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Read connectionStrings from Web.config
Message
From
07/06/2006 07:26:11
 
 
To
06/06/2006 23:21:04
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
ASP.NET
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01127527
Message ID:
01127548
Views:
8
Make sure you add reference to:
System.Configuration
It is not a default reference.

Glenn

>Dear Expert,
>I am trying to read connectionstring from Web.Config by using below codes: (I got the codes from http://msdn2.microsoft.com/en-us/library/ms178411(VS.80).aspx) ..
>
>but it doesn't work .. I meet "Object reference not set to an instance of an object." error message ..
>
>am I missing something?
>
>please help ..
>
>Thanks a lot in advance
>
>Regards
>Winanjaya
>
>
>
>Dim mConnectionString As String = ""
>Dim rootWebConfig As System.Configuration.Configuration
>Dim connString As System.Configuration.ConnectionStringSettings
>rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot")
>
>If (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0) Then
>     connString = rootWebConfig.ConnectionStrings.ConnectionStrings("cnData")
>     If Not (Nothing = connString.ConnectionString) Then
>       Console.WriteLine("my connection string = {0}", connString.ConnectionString)
>     Else
>       Console.WriteLine("my connection string does not exist!")
>     End If
>End If
>
Previous
Reply
Map
View

Click here to load this message in the networking platform