Hi All,
Can you help me with this bit of code? I'm trying to get the connection string from my web.config file, which looks something like this:
<configuration>
<connectionStrings>
<add name="SiteSqlServer" connectionString="Server=localhost;Database=DNN4_module_dev;uid=secret;pwd=supahdupahsecret;" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
Then I've got this bit of code:
Dim configAccess As System.Configuration.Configuration = WebConfigurationManager.OpenWebConfiguration("\")
HttpContext.Current.Trace.Write("SiteSqlServer", configAccess .ConnectionStrings.ConnectionStrings("SiteSqlServer").ConnectionString)
But I get an error about "Object reference not set to an instance of an object."
So the bottom line for me is: how am I supposed to access my connection string in Web.config programmatically?
Incidentally I can't alter the Web.config schema. I'm using DotNetNuke and that's how it needs the Web.config arranged.
Thanks for any pointers on this!
-jb