string userName = Request.Form.Get("txtUserName");
string userPwd = Request.Form.Get("txtUserPwd");
SqlConnection con = LoginDB.createCon();
con.Open();
SqlCommand cmd=new SqlCommand("select count(*) from admin,member serName='"+userName+"' and userPwd='"+userPwd+"'",con);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
Session["flag"] = true;
Response.Write("登陆成功");
}
else
{
Response.Write("登陆失败");
}同一个库中有两个表admin和member两个表(同为userName,userPwd两个字段),在登陆时,判断登陆时只要是两个表里的用户,用户名和密码正确就显示登陆成功.
上面的代码应该怎么写呢?
string userPwd = Request.Form.Get("txtUserPwd");
SqlConnection con = LoginDB.createCon();
con.Open();
SqlCommand cmd=new SqlCommand("select count(*) from admin,member serName='"+userName+"' and userPwd='"+userPwd+"'",con);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
Session["flag"] = true;
Response.Write("登陆成功");
}
else
{
Response.Write("登陆失败");
}同一个库中有两个表admin和member两个表(同为userName,userPwd两个字段),在登陆时,判断登陆时只要是两个表里的用户,用户名和密码正确就显示登陆成功.
上面的代码应该怎么写呢?
SqlCommand cmd=new SqlCommand("select count(*) from admin,member where (admin.userName='"+userName+"' and admin.userPwd='"+userPwd+"') OR (member.userName='"+userName+"' and member.userPwd='"+userPwd+"'),con);