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

SQL错误:select top 8 * from huikan where hklx2= and hkid<>34 <br>(ex:System.Data.OleDb.OleDbException (0x80040E14): 语法错误 (操作符丢失) 在查询表达式 'hklx2= and hkid<>34' 中。
  在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
  在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
  在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
  在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
  在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
  在 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
  在 System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  在 z.reds(String OleDb))

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

异常详细信息: System.Exception: SQL错误:select top 8 * from huikan where hklx2= and hkid<>34 <br>(ex:System.Data.OleDb.OleDbException (0x80040E14): 语法错误 (操作符丢失) 在查询表达式 'hklx2= and hkid<>34' 中。
  在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
  在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
  在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
  在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
  在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
  在 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
  在 System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  在 z.reds(String OleDb))

源错误:


行 157:                DataTable dt = S.reds("select * from huikan where hkid=" + id);
行 158:                Session["menu"] = hp.getstr(dt,"hklx2");
行 159:                Repeater4.DataSource = S.reds("select top 8 * from huikan where hklx2="+ hp.getstr(dt, "hklx2") + " and hkid<>" + id);
行 160:                Repeater4.DataBind();
行 161:                Image3.ImageUrl = hp.getstr(dt, "hktp");

源文件: f:\usr\localuser\bxw2442640143\info.aspx.cs    行: 159

堆栈跟踪:


[Exception: SQL错误:select top 8 * from huikan where hklx2= and hkid<>34 <br>(ex:System.Data.OleDb.OleDbException (0x80040E14): 语法错误 (操作符丢失) 在查询表达式 'hklx2= and hkid<>34' 中。
   在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   在 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   在 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 z.reds(String OleDb))]
   z.reds(String OleDb) +479
   Sql_Helper.reds(String cmdText) +195
   news.Page_Load(Object sender, EventArgs e) in f:\usr\localuser\bxw2442640143\info.aspx.cs:159
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772


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