ExecuteReader

[murugavelmsc]

Hi,

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

[code=cpp]
protected void Button1_Click(o bject sender, EventArgs e)
{
string constr=Configur ationSettings.A ppSettings["Myconn"];
SqlConnection conn = new SqlConnection(c onstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from users where username='" + txtusername.Tex t + "' and user_password=' " + txtpassword.Tex t + "'";
SqlDataReader rd = cmd.ExecuteRead er();

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

conn.Close();

}[/code]

[vee10]

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

cmd .Connection = conn;

Hi,

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


protected void Button1_Click(o bject sender, EventArgs e)
{
string constr=Configur ationSettings.A ppSettings["Myconn"];
SqlConnection conn = new SqlConnection(c onstr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from users where username='" + txtusername.Tex t + "' and user_password=' " + txtpassword.Tex t + "'";
SqlDataReader rd = cmd.ExecuteRead er();

if (rd.HasRows == true)
{
Response.Redire ct("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.