protected void btnlogin_Click(object sender, EventArgs e)
{
username = uname.Text;
password = pword.Text;
CsUserlist userinfo = new CsUserlist(username, password);
if (ConnectionClass.SignIn(userinfo))
{
FormsAuthentication.RedirectFromLoginPage(username, CheckBox.Checked);
}
else
{
Response.Write("<script type='text/javascript'>");
Response.Write("alert('Please check your username and password');");
Response.Write("</script>");
}
}
public static bool SignIn(CsUserlist userinfo)
{
string aQuery = string.Format(@"SELECT count(username) from userlist where username=('{0}') and password=('{1}')",
userinfo.username, userinfo.password);
cmdString = new SqlCommand(aQuery, cntString);
cntString.Open();
try {
int count = (int)cmdString.ExecuteScalar();
cntString.Close();
return(count > 0);
}
finally
{
cntString.Close();
}
}
