skip to Main Content

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.

2

Answers


  1. 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:

    enter image description here

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

    enter image description here

    Login or Signup to reply.
  2. 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;
    
    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search