SqlConnection cn = new SqlConnection();
cn.ConnectionString=System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnn"].ToString();
cn.Open();
string cmd = "select id,Password from LogIn where id=@LoginID and Password=@Password";
SqlCommand cmd = new SqlCommand(cmd,cn);
cmd.Parameters.AddWithValue("@LoginID", TextBox1.Text);
cmd.Parameters.AddWithValue("@Password", TextBox2.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.Redirect("groupdeatils.aspx");
}
else
{
Response.Write("Invalid attempt to login");
}