我想在用户登录时,同时记录ID到Session里面,但我不想在表示层有填写主键ID,请问怎么写方法?
这是我登录时的方法
public bool IsExists(string name, string pw, string rank)
{
bool flag = false;
string sql = "select * from ManageAdmin where AdminName='" + name + "' and AdminPw='" + pw + "' and AdminRank='" + rank + "'";
DataTable dt = sqlhelper.ExecuteQuery(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
flag = true;
}
return flag;
}
这是我登录时的方法
public bool IsExists(string name, string pw, string rank)
{
bool flag = false;
string sql = "select * from ManageAdmin where AdminName='" + name + "' and AdminPw='" + pw + "' and AdminRank='" + rank + "'";
DataTable dt = sqlhelper.ExecuteQuery(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
flag = true;
}
return flag;
}
然后下面代码public bool IsExists(string name, string pw, string rank)
{
bool flag = false;
string sql = "select * from ManageAdmin where AdminName='" + name + "' and AdminPw='" + pw + "' and AdminRank='" + rank + "'";
DataTable dt = sqlhelper.ExecuteQuery(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
Session["ID"]=dt[0]["id"].ToString();
flag = true;
}
return flag;
}这样就完事了
性能会高
"abc#123#cba#321"
您之要提起时候节选一下字符串就可以了