Question

第 1 行: ',' 附近有语法错误。

string sql = "select AdminName,AdminPwd from Web_Admin where AdminName='" + TxtAdminName.Text.Trim() +"', AdminPwd='" + TxtAdminPwd.Text.Trim() +"'";
DataTable dt=new DataTable();
dt=odb.ExeSql(sql).Tables[0];
if (dt.Rows.Count > 0)
{
Session["AdminUserName"] = TxtAdminName.Text.Trim();
Session["AdminPassWord"] = TxtAdminPwd.Text.Trim();
Response.Redirect("~/admin/index.aspx");
}
else
{
Label1.Text = "用户名称或密码错误！";
return;
}
登录窗口代码如下，出现以上错误， 怎么改呢？？？

Answer 1

我晕
where 后面条件不是用 ,分隔
应该是 and

select AdminName,AdminPwd from Web_Admin where AdminName='" + TxtAdminName.Text.Trim() +"' and AdminPwd='" + TxtAdminPwd.Text.Trim() +"'";

Answer 2

where 语句的逗号改成and试试