The ConnectionString property has not been initialized

Question

0.00/5 (No votes)

See more:

I am developing a project in vs 2005.

I am trying to connect to a database and have stored the connection string in app.config file.

I am using the below code-

private void button1_Click(object sender, EventArgs e)
       {
           //SqlConnection con = new SqlConnection();
           //con.ConnectionString = "Server=./SqlExpress;Database=Northwind;Trusted_Connection=true";
           String con = ConfigurationManager.AppSettings["ConnectionString"];
           SqlConnection cont = new SqlConnection(con);

           try
           {
               cont.Open();
               System.Windows.Forms.MessageBox.Show("Sucess");
           }
           catch (Exception ed)
           {
               MessageBox.Show("Unsucess" + ed.Message);
           }
       }

My app.config file is as below

<configuration>
    <configsections>
    </configsections>
    <connectionstrings>
        <add key="ConnectionString" value="Data Source=A01hw306775\SQLEXPRESS;Initial Catalog=NorthWind;Integrated Security=True" />
    </connectionstrings>
</configuration>

When executing i get the following error

Connection string property not initialised.

Please let me know what has to be done to remove the error

Posted 5-Jul-11 19:32pm

bsb25

Updated 5-Jul-11 20:51pm

Ramalinga Koushik

v3

Add a Solution

Comments

TweakBird 6-Jul-11 1:40am

Did you tried in Google ?

bsb25 6-Jul-11 1:43am

searched for it in google,but none of the soln are workin..

TweakBird 6-Jul-11 1:45am

Try Uday P.Singh answer.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday P.Singh · Answer 1 · 2011-07-05T19:43:00

Solution 1

what is your code in app.config? Make sure you have written something like this:

XML

<configuration>
  <appSettings>
    <add key="ConnectionString" value="Data Source=ABC\SQLEXPRESS;Initial Catalog=mydb;Integrated Security=True"/>
  </appSettings>
</configuration>

And always check that you are using the right app.confing file if you have more than one app.config.

Posted 5-Jul-11 19:43pm

Uday P.Singh

Updated 5-Jul-11 19:44pm

v2

Comments

bsb25 6-Jul-11 1:50am

its still thwoing the same exception.

Uday P.Singh 6-Jul-11 1:53am

does your solution has more than one app.config?

bsb25 6-Jul-11 1:55am

no..i have only one app.config file.

Uday P.Singh 6-Jul-11 2:26am

write my answer code in your app.confing and use this line to call this:
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];

it will surely resolve your problem.

walterhevedeich · Answer 2 · 2011-07-05T20:21:00

Solution 2

Change to following code:

String con = ConfigurationManager.AppSettings["ConnectionString"];

to

String con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

Posted 5-Jul-11 20:21pm

walterhevedeich

2irfanshaikh · Answer 3 · 2011-07-05T20:24:00

 private void button1_Click(object sender, EventArgs e)
        {
            //SqlConnection con = new SqlConnection();
            //con.ConnectionString = "Server=./SqlExpress;Database=Northwind;Trusted_Connection=true";
//changes            
string con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//Changes         
   SqlConnection cont = new SqlConnection(con);
          
            try
            {
                cont.Open();
                System.Windows.Forms.MessageBox.Show("Sucess");
            }
            catch (Exception ed)
            {
                MessageBox.Show("Unsucess" + ed.Message);
            }
        }

also change you config file

XML

<configuration>
    <connectionStrings>
        <add name="ConnectionString" connectionString="Data Source=A01hw306775\SQLEXPRESS;Initial Catalog=NorthWind;Integrated Security=True" />
    </connectionStrings>
</configuration>