字符串的语法异常 在查询表达式 '1=1 and NType='tzgg order by NOrderNum asc, NAddTime desc' 中
字符串的语法错误 在查询表达式 '1=1 and NType='tzgg order by NOrderNum asc, NAddTime desc' 中
public partial class index1 : System.Web.UI.Page
{
private InfoBLL infobll = new InfoBLL();
private AboutBLL aboutbll = new AboutBLL();
protected String type
{
get
{
return Request.QueryString["type"];
}
set
{
type = value;
}
}
private int page
{
get
{
if (!String.IsNullOrEmpty(Request["page"]))
{
return Int32.Parse(Request.QueryString["page"] + "");
}
return 1;
}
set
{
page = value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
rep_list1.DataSource = infobll.GetInfoList("and NType='tzgg");
//rep_list1.DataSource = rep_list1.GetList("6", "");
//Repeater1.DataSource = GetList("10", "");
this.rep_list1.DataBind();
this.rep_list.DataSource = infobll.GetInfoList(6,"tjyd");
this.rep_list.DataBind();
BLL.LinkBLL by = new T_angel.BLL.LinkBLL();
Repeater1.DataSource = by.GetLinkList("");
Repeater1.DataBind();
高手帮看看错哪了
------解决方案--------------------
我很奇怪,为何在tagg前加单引号?
要加的话,也是加两个,转义用
------解决方案--------------------
infobll.GetInfoList(" and NType='tzgg' ");
*****************************************************************************
签名档: http://feiyun0112.cnblogs.com/
public partial class index1 : System.Web.UI.Page
{
private InfoBLL infobll = new InfoBLL();
private AboutBLL aboutbll = new AboutBLL();
protected String type
{
get
{
return Request.QueryString["type"];
}
set
{
type = value;
}
}
private int page
{
get
{
if (!String.IsNullOrEmpty(Request["page"]))
{
return Int32.Parse(Request.QueryString["page"] + "");
}
return 1;
}
set
{
page = value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
rep_list1.DataSource = infobll.GetInfoList("and NType='tzgg");
//rep_list1.DataSource = rep_list1.GetList("6", "");
//Repeater1.DataSource = GetList("10", "");
this.rep_list1.DataBind();
this.rep_list.DataSource = infobll.GetInfoList(6,"tjyd");
this.rep_list.DataBind();
BLL.LinkBLL by = new T_angel.BLL.LinkBLL();
Repeater1.DataSource = by.GetLinkList("");
Repeater1.DataBind();
高手帮看看错哪了
------解决方案--------------------
我很奇怪,为何在tagg前加单引号?
要加的话,也是加两个,转义用
------解决方案--------------------
infobll.GetInfoList(" and NType='tzgg' ");
*****************************************************************************
签名档: http://feiyun0112.cnblogs.com/