protected void btnLogin_Click(object sender, EventArgs e)
{
DataSet1TableAdapters.MyUsersTableAdapter users = new DataSet1TableAdapters.MyUsersTableAdapter();
int numberOfUsers = users.LoginQuery(txtUser.Text, txtPass.Text).GetValueOrDefault();
if (numberOfUsers > 0)
{
// login successful!
Session.Add("status", "Login");
Response.Redirect("Default.aspx");
// using QueryString
//Response.Redirect("Default.aspx?status=Login");
}
else
{
// Failed!
txtPass.Text = "";
txtUser.Text = "";
lblErr.Text = "Login failed! Please try again!";
txtUser.BorderColor = System.Drawing.Color.Red;
}
}
