I have a configuration file in a wpf project to store a connection string. But when I try to get AppSettings and ConnectionStrings, I get null.
The WEB.config file looks like this:
<?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add name="Trackboard" connectionString="Data Source=(localdb)\v11.0;Initial Catalog=Trackboard;Integrated Security=True;AttachDbFileName=E:\Users\Sean\Workspace\DATABASE\Trackboard.mdf"/> </connectionStrings> <appSettings> <add key="Trackboard" value="Data Source=(localdb)\v11.0;Initial Catalog=Trackboard;Integrated Security=True;AttachDbFileName=E:\Users\Sean\Workspace\DATABASE\Trackboard.mdf"/> </appSettings> </configuration>
I tried several ways:
W1: ConnStr = ConfigurationManager.ConnectionStrings["Trackboard"].ConnectionString; W2: ConnStr = ConfigurationManager.ConnectionStrings[0].ConnectionString; W3: ConnStr = ConfigurationManager.AppSettings["Trackboard"]; W4: ConnStr = ConfigurationManager.AppSettings[0];
None of them worked.
But it worked:
ConnStr = @"Data Source=(localdb)\v11.0;Initial Catalog=Trackboard;Integrated Security=True;AttachDbFileName=E:\Users\Sean\Workspace\DATABASE\Trackboard.mdf";
(This means that I cannot use the configuration file, which is against my will) I need help.
source share