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

语法错误 (操作符丢失) 在查询表达式 'n_product = '可用' and n_id<> and n_type='' and n_enable = '是'' 中。

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

异常详细信息: System.Data.OleDb.OleDbException: 语法错误 (操作符丢失) 在查询表达式 'n_product = '可用' and n_id<> and n_type='' and n_enable = '是'' 中。

源错误:


行 60:         OleDbDataAdapter dbdap = new OleDbDataAdapter(sql, mycon);
行 61:         DataSet ds = new DataSet();
行 62:         dbdap.Fill(ds);
行 63:         dbdap.Dispose();
行 64:         mycon.Close();

源文件: d:\47\wwwroot\szyufalong\web\App_Code\oleaccess.cs    行: 62

堆栈跟踪:


[OleDbException (0x80040e14): 语法错误 (操作符丢失) 在查询表达式 'n_product = '可用' and n_id<> and n_type='' and n_enable = '是'' 中。]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1212805
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +256
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +216
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +60
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +164
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +115
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +89
   oleaccess.SelectData(String sql) in d:\47\wwwroot\szyufalong\web\App_Code\oleaccess.cs:62
   prodetail.Page_Load(Object sender, EventArgs e) in d:\47\wwwroot\szyufalong\web\prodetail.aspx.cs:109
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


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