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

语法错误。 在查询表达式 'id not in (SELECT TOP 0 id FROM sl_article where  classid in (57) order by paixu desc , id desc)  and   classid in (57)' 中。

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

异常详细信息: System.Data.OleDb.OleDbException: 语法错误。 在查询表达式 'id not in (SELECT TOP 0 id FROM sl_article where  classid in (57) order by paixu desc , id desc)  and   classid in (57)' 中。

源错误:


行 125:                else
行 126:                {
行 127:                    adapter.Fill(dset, "xuesheng");
行 128:                }
行 129:                adapter.Dispose();

源文件: d:\wwwroot\hkaihua\wwwroot\App_Code\my_conn.cs    行: 127

堆栈跟踪:


[OleDbException (0x80040e14): 语法错误。 在查询表达式 'id not in (SELECT TOP 0 id FROM sl_article where  classid in (57) order by paixu desc , id desc)  and   classid in (57)' 中。]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1233516
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +247
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +208
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +162
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +110
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +9
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +136
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +86
   my_conn.GetTable(String g1) in d:\wwwroot\hkaihua\wwwroot\App_Code\my_conn.cs:127
   my_html.page_w_list(String sql, String sql2, String list_content, String file_content, String list_c, Int32 page) in d:\wwwroot\hkaihua\wwwroot\App_Code\my_html.cs:2554
   my_html.set_w_list(String table_name, String n_id, Int32 page) in d:\wwwroot\hkaihua\wwwroot\App_Code\my_html.cs:3001
   list.Page_Load(Object sender, EventArgs e) in d:\wwwroot\hkaihua\wwwroot\list.aspx.cs:111
   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.7.4087.0