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

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

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

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

源错误:


行 104:            if (Function.RteNum(cid))
行 105:            {
行 106:                SqlDataReader dr_city = ANDY_SP.Pr_Dr("select * from tbl_class where ParentId=" + Function.GetColumn(cid, "parentid") + " order by orderid asc");
行 107:                while (dr_city.Read())
行 108:                {

源文件: d:\wwwroot\abieweb2021\schoollist.aspx.cs    行: 106

堆栈跟踪:


[SqlException (0x80131904): 关键字 'order' 附近有语法错误。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2555926
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5959200
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +285
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4169
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
   System.Data.SqlClient.SqlDataReader.get_MetaData() +89
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +430
   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) +2598
   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) +1483
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +64
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +240
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +81
   ANDY.Common.DBClass.RunProcedure(String storedProcName, IDataParameter[] parameters) in E:\Project\jxt\爱贝官网abiechina.com\ANDY.Common\DBClass.cs:122
   ANDY.Common.ANDY_SP.Pr_Dr(String SQL_Str) in E:\Project\jxt\爱贝官网abiechina.com\ANDY.Common\ANDY_SP.cs:128

[Exception: 关键字 'order' 附近有语法错误。]
   ANDY.Common.ANDY_SP.Pr_Dr(String SQL_Str) in E:\Project\jxt\爱贝官网abiechina.com\ANDY.Common\ANDY_SP.cs:132
   schoollist.LoadSelect() in d:\wwwroot\abieweb2021\schoollist.aspx.cs:106
   schoollist.Page_Load(Object sender, EventArgs e) in d:\wwwroot\abieweb2021\schoollist.aspx.cs:18
   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.3282.0