在如图所示的登录窗体中,两个文本框控件textBox1和textBox2,两个命令按钮控件button1和button2。“登录”为button1,“退出”为button2。在Access数据库d:\user中有用户表userinfo(userid、username、userpwd)。分别在两个文本框中输入用户名和密码,单击“登录”,当用户为合法用户时,将本窗体隐藏,显示manager窗体;否则提示为“用户名或密码错误”。请写出button1的单击事件。(求助啊!!!)
调试欢乐多
string userName = txtUserId.Text.Trim();
string password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtPassword.Text.Trim(), "MD5").Substring(8, 16).ToLower();
userInfo = WKM_AdminManager.CheckUserLogin(userName, password);
if (userInfo != null)
{
Session["CurrentUser"] = userInfo;
Session["ErrorNum"] = 0;
ModifyAdminLoginInfo(userInfo);
Response.Redirect("Index.aspx");
}
else
{
Response.Write("<script>alert('用户名或密码不正确!')</script>");
}
OleDbCommand cmd=new OleDbCommand("select count(*) from userinfo where username='"+TextBox1.Text.Trim()+"' and userpwd='"+TextBox2.Text.Trim()+"'",cn);
cn.Open();
if((int)cmd.ExecuteScalar()==1)
//将本窗体隐藏,显示manager窗体
else
//提示为“用户名或密码错误”
cn.Close();