ExecuteReader Connection property has not been initialized

Question

ExecuteReader  Connection property has   not been initialized    my coding is  protected void Button2 Click object sender  EventArgs e                SqlConnection conn   new SqlConnection  Data Source Si-6  SQLSERVER2005 Initial Catalog rags Integrated Security SSPI         SqlDataReader rdr   null       try                  2  Open the connection         conn Open                3  Pass the connection to a command object           SqlCommand cmd   new SqlCommand  select   from Customers   conn           SqlCommand cmd new SqlCommand   insert into time project iteration                    values    this  name1  SelectedValue        this  iteration  SelectedValue                                4  Use the connection                        get query results         rdr   cmd ExecuteReader                print the CustomerID of each record         while  rdr Read                          Console WriteLine rdr 0                        finally                  close the reader         if  rdr    null                        rdr Close                          5  Close the connection         if  conn    null                        conn Close

User · Answer

After  SqlCommand cmd new SqlCommand   insert into time project iteration values       Add   cmd Connection   conn    Hope this help

User · Answer

you have to assign connection to your command object  like    SqlCommand cmd new SqlCommand   insert into time project iteration values    this  name1  SelectedValue        this  iteration  SelectedValue         cmd Connection   conn

User · Answer

As mentioned you should assign the connection and you should preferably also use sql parameters instead  so your command assignment would read           3  Pass the connection to a command object     SqlCommand cmd new SqlCommand   insert into time project iteration  values   project   iteration    conn         conn   added     cmd Parameters Add  project   System Data SqlDbType NVarChar  Value   this name1 SelectedValue      cmd Parameters Add  iteration   System Data SqlDbType NVarChar  Value   this name1 SelectedValue                 4  Use the connection          By using parameters you avoid SQL injection and other problematic typos  project names like  myproject s  is an example

User · Answer

I like to place all my sql connections in using statements   I think they look cleaner  and they clean up after themselves when your done with them   I also recommend parameterizing every query  not only is it much safer but it is easier to maintain if you need to come back and make changes      create open connection using  SqlConnection conn   new SqlConnection  Data Source Si-6  SQLSERVER2005 Initial Catalog rags Integrated Security SSPI         try               conn Open                initialize command         using  SqlCommand cmd   conn CreateCommand                              generate query with parameters             with cmd                                CommandType   CommandType Text                   CommandText    insert into time project iteration  values  name   iteration                     Parameters Add new SqlParameter   name   this name1 SelectedValue                     Parameters Add new SqlParameter   iteration   this iteration SelectedValue                     ExecuteNonQuery                                      catch  Exception                  throw            finally               if  conn    null  amp  amp  conn State    ConnectionState Open                        conn Close

User · Answer

use this and pass connection object     SqlCommand cmd new SqlCommand   insert into time project iteration values    this  name1  SelectedValue        this  iteration  SelectedValue       conn

User · Answer

You can also write this   SqlCommand cmd new SqlCommand   insert into time project iteration  values   project   iteration    conn   cmd Parameters AddWithValue   project  name1 SelectedValue   cmd Parameters AddWithValue   iteration  iteration SelectedValue

User · Answer

All of the answers is true This is another way  And I like this One  SqlCommand cmd   conn CreateCommand     you must notice that strings concat have a sql injection problem  Use the Parameters http   msdn microsoft com en-us library system data sqlclient sqlcommand parameters aspx

[c#] ExecuteReader: Connection property has not been initialized

Examples related to c#

Examples related to asp.net

Examples related to sql-server-2005