Loading

SelectCommand.Connection property has not been initialized.

asha pawar

con = new SqlConnection(s);

con.Open();

SqlCommand cmd = new SqlCommand("select count (*) from login where emailadd='" + txtemail.Text + "' and pass='" + txtpass.Text + "'");

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

cmd.ExecuteNonQuery();

if(dt.Rows[0][0].ToString()=="1")

{ Response.Write("");

Response.Redirect("Home.aspx");

}

con.Close();

1 Reply

Know the answer? Post it — somebody with the same question will find it here.