ExecuteReader

[murugavelmsc]

Hi,

In Visual studio 2008, i got a error "ExecuteReader: Connection property has not been initialized" . So guide me

 protected void Button1_Click(object sender, EventArgs e)
    {
        string constr=ConfigurationSettings.AppSettings["Myconn"];
        SqlConnection conn = new SqlConnection(constr);
        conn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select * from users where username='" + txtusername.Text + "' and user_password='" + txtpassword.Text + "'";
        SqlDataReader rd = cmd.ExecuteReader();
 
            if (rd.HasRows == true)
            {
                Response.Redirect("Index.aspx");
            }
 
        conn.Close();
 
    }

[vee10]

Hi,
u should initialize the connection property of the sqlcommand variable

 
cmd .Connection = conn;
 
 

Hi,

In Visual studio 2008, i got a error "ExecuteReader: Connection property has not been initialized" . So guide me


protected void Button1_Click(object sender, EventArgs e)
{
string constr=ConfigurationSettings.AppSettings["Myconn"];
SqlConnection conn = new SqlConnection(constr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from users where username='" + txtusername.Text + "' and user_password='" + txtpassword.Text + "'";
SqlDataReader rd = cmd.ExecuteReader();

if (rd.HasRows == true)
{
Response.Redirect("Index.aspx");
}

conn.Close();

}

[Plater]

You need to associate the command object with the connection object.
I believe it can be done in the constructor as well as setting a property.