语法错误 (操作符丢失) 在查询表达式 'lm= and sh='1'' 中。
//根据栏目ID来绑定文章
private void BindWz( string lmid)
{
DataTable dt = DBhelper2.ExecuteTable("select id,lm,bt,sj,tp from wzb where lm=" + lmid + " and sh='1' order by sx"); if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count == 1)
{
BindWzByWzId(dt.Rows[0]["id"].ToString());
}
else
{
if (lmid == "92")
{
//视频
RptSp.DataSource = dt;
RptSp.DataBind();
}
else if (lmid == "93")
{
//图片
DLPicture.DataSource = dt;
DLPicture.DataBind();
}
else
{
rptWz.DataSource = dt;
rptWz.DataBind();
}
}
}
}
我语句怎么看都正确啊,为什么总是报操作符丢失的错误?
//根据栏目ID来绑定文章
private void BindWz( string lmid)
{
DataTable dt = DBhelper2.ExecuteTable("select id,lm,bt,sj,tp from wzb where lm=" + lmid + " and sh='1' order by sx"); if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows.Count == 1)
{
BindWzByWzId(dt.Rows[0]["id"].ToString());
}
else
{
if (lmid == "92")
{
//视频
RptSp.DataSource = dt;
RptSp.DataBind();
}
else if (lmid == "93")
{
//图片
DLPicture.DataSource = dt;
DLPicture.DataBind();
}
else
{
rptWz.DataSource = dt;
rptWz.DataBind();
}
}
}
}
我语句怎么看都正确啊,为什么总是报操作符丢失的错误?
{
if (Request.QueryString["lm"] != null)
return Request.QueryString["lm"];
else
return "1";
}
对Lm值判断,就可以了,谢谢大家了