• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2762
  • Last Modified:

Connectionstring App.config / App.Settings

I have a strage problem. When trying to read the connectionstring from App.config (System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString) I get Null Reference Exception even if the connection string is correct written in the App.config file. I have also set correct reference to the System.configuration.dll. When I put the connectionsting in a App.settings file it works without problems. I have tried everything and is going nuts. What can cause this problem?

Please see attached code :)
-----------------------------
App.config
-----------------------------
 
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
	<configSections></configSections>
	<connectionStrings>
  <add name="ConnectionString" connectionString="Data Source=localhost;Initial Catalog=Rank;Persist Security Info=True;User ID=Rank;Password=Password;"
   providerName="System.Data.SqlClient" />
  <add name="Rank.App.ConnectionString" connectionString="Data Source=localhost;Initial Catalog=Rank;Persist Security Info=True;User ID=Rank;Password=Password;" />
 </connectionStrings>
</configuration>
 
namespace Rank
{
    public class Common
    {
        public class Data
        {
            public static string ConnectionString
            {
                get
                {
                    //THIS DONT WORK:
                    //return System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 
                    //THIS WORK PERFECT:
                    return App.Default.ConnectionString.ToString();
                }
            }
        }
    }
}

Open in new window

0
webressurs
Asked:
webressurs
2 Solutions
 
HarryNSCommented:
MessageBox.Show(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

With the app.config you mentioned, when I tried here I am able to retrieve the following result,

Data Source=localhost;Initial Catalog=Rank;Persist Security Info=True;User ID=Rank;Password=Password;
0
 
csharppCommented:
Use this:

return System.Configuration.ConfigurationManager.ConnectionStrings["Rank.App.ConnectionString"].ConnectionString;

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now