How to add connection string in Config File in WPF Application

Question

I am a beginner and learning WPF Application. I have a simple project and in that I want to read DB Configuration string from App.Config File. But I am not able to do so. Below is my attempt:

APP.Config File:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
    </startup>
  <connectionStrings>
    <add name="DBCS" connectionString="Data Source=.\;Initial Catalog=Connect;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

CS Code:

    public static void GetDataFromDB()
            {
                //var CS = @"Data Source=.\;Initial Catalog=Connect;Integrated Security=SSPI";
               // ABOVE CODE WORKS FINE
                string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
                using (SqlConnection con = new SqlConnection(CS))
                {
                    con.Open();
                    SqlDataAdapter da = new SqlDataAdapter("Select * from tblTenant", con);
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                }
            }

Edit:

You may want to change the elements in your config to capital letters. It might be case sensitive.. Not sure. — Brandon Miller
– Brandon Miller, Commented Mar 21, 2018 at 15:12
I have a ASP.Net web project their I have EXACT same settings and it works fine. :-|. Only difference there I have added this in web.config file. — Unbreakable
– Unbreakable, Commented Mar 21, 2018 at 15:19

mm8 · Accepted Answer · 2018-03-21 15:26:09Z

8

You need to put the connnection string in the App.config of the running WPF application and not in the DAL or any other class library.

The ConfigurationManager class reads the configuration file of the running executable.

answered Mar 21, 2018 at 15:26

mm8

170k10 gold badges70 silver badges102 bronze badges

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

Comments

David Brunning · Accepted Answer · 2018-03-21 15:22:02Z

0

Add "clear" to your app.config before the connections string definition. It will look like this :

<connectionStrings>
  <clear/>
  <add name="DBCS" connectionString="Data Source=.\;Initial Catalog=Connect;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
</connectionStrings>

answered Mar 21, 2018 at 15:22

David Brunning

6698 silver badges22 bronze badges

2 Comments

David Brunning Over a year ago

Can you be more explicit? Still a null reference, or a different error? I put the same thing into a WPF application and it was fine. Presumably your configuration manager is System.Configuration.ConfigurationManager? Also, if you look at the ConfigurationManager.ConnectionStrings collection, is it empty? In my code, I reference the collection by index, not name, i.e. ConnectionStrings[0].ConnectionString (But actually, both work).

Unbreakable Over a year ago

I did silly mistake. Actually my app.config file was in different project which was added as a class library. Sorry for the confusion. I am a beginner so I did not know that.

Andrei Ivanov · Accepted Answer · 2018-03-21 15:28:30Z

0

Try to change in the App.config:

edited Mar 21, 2018 at 15:28

answered Mar 21, 2018 at 15:25

Andrei Ivanov

1501 silver badge9 bronze badges

1 Comment

Andrei Ivanov Over a year ago

Try than in the App.config to replace with: <add name="DBCS" connectionString="Data Source=.\;Initial Catalog=Connect;Integrated Security=SSPI" providerName="System.Data.SqlClient" />

Suruhj · Accepted Answer · 2021-04-19 10:20:59Z

0

You can add Connection string to both DAL and UI projects.

Try removing Data Source =.\ to Data Source =.

answered Apr 19, 2021 at 10:20

Suruhj

33 bronze badges

Collectives™ on Stack Overflow

How to add connection string in Config File in WPF Application

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related