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

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

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

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

源错误:


行 180:				}
行 181:			}
行 182:			obj = myCmd.ExecuteScalar();
行 183:		}
行 184:		catch (Exception ex) {

源文件: d:\wwwroot\wzjs2012080012\web\App_Code\DBClass.cs    行: 182

堆栈跟踪:


[SqlException (0x80131904): 关键字 'and' 附近有语法错误。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2585494
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6038654
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +91
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +446
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2698
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +1611
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +65
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +283
   DB.ExecuteScalarSQL(String StrSQL, SqlParameter[] prams) in d:\wwwroot\wzjs2012080012\web\App_Code\DBClass.cs:182

[MyException: 关键字 'and' 附近有语法错误。]
   DB.ExecuteScalarSQL(String StrSQL, SqlParameter[] prams) in d:\wwwroot\wzjs2012080012\web\App_Code\DBClass.cs:185
   course_left.GetCurrentlyParentIDStyle(String _PageID, String _UrlID) in d:\wwwroot\wzjs2012080012\web\course\left.ascx.cs:123
   ASP.course_left_ascx.__DataBind__control5(Object sender, EventArgs e) in d:\wwwroot\wzjs2012080012\web\course\left.ascx:69
   System.Web.UI.Control.OnDataBinding(EventArgs e) +86
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +154
   System.Web.UI.Control.DataBind() +17
   System.Web.UI.Control.DataBindChildren() +187
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +164
   System.Web.UI.Control.DataBind() +17
   System.Web.UI.Control.DataBindChildren() +187
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +164
   System.Web.UI.Control.DataBind() +17
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +128
   System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) +220
   System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) +73
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +229
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +63
   System.Web.UI.WebControls.Repeater.DataBind() +81
   Bind.Bind_rpt_bySql(Repeater rpt, String sql) in d:\wwwroot\wzjs2012080012\web\App_Code\Bind.cs:82
   course_left.FillData() in d:\wwwroot\wzjs2012080012\web\course\left.ascx.cs:50
   course_left.Page_Load(Object sender, EventArgs e) in d:\wwwroot\wzjs2012080012\web\course\left.ascx.cs:32
   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.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


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