ConfigurationManager ConnectionString not working-CodePudding

I have this project I am working on and I want to "hide" my connection string from my main class and place it to the App.Config.

While trying to access the connection string from the main class I get this error "System.Configuration.ConnectionStringSettingsCollection.this[string].get returned null."

This is my main class code that I use to get the conn string:

string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString.ToString();

This is my App.Config code:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add name="ConnString" connectionString="Password=XXXX;Persist Security Info=True;User ID=XXXX;Initial Catalog=XXXX;Data Source=XXXX"/>
    </connectionStrings>
</configuration>

Note: I have to add the app.config by myself as a new class. Also the connection string works perfect when it's in the main class, so it's not its fault.

CodePudding user response：

The WebConfig connection string should be like this:

<connectionStrings>
    <add name="DBCS" connectionString="server=.;database=MVCCrud;integrated security=SSPI" providerName="Sql.Data.SqlClient" />
</connectionStrings>

The main class connection string should be like this:

string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

CodePudding user response：

I added config, added you code and configuration and it worked.

I can't add this as a comment, as I can't post images there, that's why I am writing an answer.

So, just to make sure you added the file in a correct way:

right click your project, add -> new item:

and then just find appropriate file to add (you can make use of search text box):