“/”应用程序中的服务器错误。

关键字 'and' 附近有语法错误。
关键字 'order' 附近有语法错误。

说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Exception: 关键字 'and' 附近有语法错误。
关键字 'order' 附近有语法错误。

源错误:


行 52:         DevPager1.RecordCount = DB.GetDataSetCount("count(0)", "TypePic", " fenqu is not null", "");
行 53:         DevPager1.DevWebUrl = "online/{0}.htm";
行 54:         this.rptflzs.DataSource = DB.GetPager(DevPager1.PageIndex, DevPager1.PageSize, "TypePic.BusinessId,AddUser,TypePic.IsVip,TypePic.BusPic,s_oname,picone,pictwo", "TypePic,Business", " where Business.BusinessId=TypePic.BusinessId and VIPtype>0 and Id not in (select top 88 id from typepic where fenqu is not null  order by TPNum asc,id desc ) and fenqu is not null and TypePic.BusinessId!=3490", " and Business.BusinessId=TypePic.BusinessId and VIPtype>0 and and Id not in (select top 88 id from typepic where fenqu is not null  order by TPNum asc,id desc ) and fenqu is not null and TypePic.BusinessId!=3490", " order by TPNum asc, Id desc", " Id ");
行 55:         this.rptflzs.DataBind();
行 56: 

源文件: e:\wwwroot\www.3456.tv\online\Default.aspx.cs    行: 54

堆栈跟踪:


[Exception: 关键字 'and' 附近有语法错误。
关键字 'order' 附近有语法错误。]
   DB.GetPager(Int32 currpage, Int32 pagesize, String columns, String tablename, String where, String searchwhere, String order, String keyid) +692
   online_Default.DataBind() in e:\wwwroot\www.3456.tv\online\Default.aspx.cs:54
   online_Default.Page_Load(Object sender, EventArgs e) in e:\wwwroot\www.3456.tv\online\Default.aspx.cs:22
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678


版本信息: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.6.1590.0