connection property has not been initialized

Question

hi all

i am developing winforms application in c#

My ConnectionString in app.config is 

 

<add name="MyConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\UttamPayDB.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

my code is

 try
   {

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
    
     SqlCommand cmd = new SqlCommand("select * into " + ctable + " from " + ptable + "");
     con.Open();
     cmd.ExecuteNonQuery();

     con.close();

}

at the execution of nonquery it says 

connection property has not been initialized

 

Answer 1

You forgot to assign the connection to the command:

cmd.Connction = con;

 

Hope that helps,

Dark

 

Answer 2

thanks darkpwny

again you helped me..

it was my mistake..