ConfigurationManager in WPF

Question

I have a config file in a wpf project to store the connectionstring. But when I try to get AppSettings and ConnectionStrings, I get null.

the WEB.config file is 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 in 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 this one worked:

ConnStr = @"Data Source=(localdb)\v11.0;Initial Catalog=Trackboard;Integrated Security=True;AttachDbFileName=E:\Users\Sean\Workspace\DATABASE\Trackboard.mdf";

(That means I cannot use a config file, which is against my will) I need help.

Why you choose WEB.config for WPF app. It have to the APP.config. — Toan Vo
– Toan Vo, Commented Feb 7, 2014 at 7:47

Mayur Dhingra · Accepted Answer · 2014-02-07 09:59:52Z

15

Just add an app.config and not web.config because it is not a web application.

And after that it's too simple, just add a reference to to System.Configuration and then use this.

var ConnStr = ConfigurationManager.AppSettings["Trackboard"];

edited Feb 7, 2014 at 9:59

answered Feb 7, 2014 at 9:54

Mayur Dhingra

1,58711 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nagaraj S · Accepted Answer · 2014-02-07 07:56:40Z

2

This one use System.Configuration namespace

using System.Configuration;

Or add System.Configuration in reference

System.ConfigurationManager.ConnectionStrings["Trackboard"].ConnectionString;
System.ConfigurationManager.ConnectionStrings[0].ConnectionString;

answered Feb 7, 2014 at 7:56

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

1 Comment

Sean C. Over a year ago

I did add the System.Configuration reference and namespace. The problem seems to be that System.ConfigurationManager.ConnectionStrings has a count of 0, that's why I can't get the value by key or index.It's weird.It works in winform application.

Pang · Accepted Answer · 2020-11-05 00:15:51Z

2

I've figured it out! I shouldn't have created a new config file. There is a default app.config file in the project. Now everything is fine.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="Trackboard.Properties.Settings.TrackboardConnectionString"
            connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\DATABASE\Trackboard.mdf;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

private static string ConnStr = ConfigurationManager.ConnectionStrings["Trackboard.Properties.Settings.TrackboardConnectionString"].ConnectionString;

edited Nov 5, 2020 at 0:15

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Feb 8, 2014 at 8:28

Sean C.

1,6232 gold badges14 silver badges23 bronze badges

Collectives™ on Stack Overflow

ConfigurationManager in WPF

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related