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

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

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

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

源错误:


行 42:                          dbo.formatAmount_s(amount,3) as amount, cinema, counter,'http://www.cbooo.cn/moviepic/'+m.is_img as is_img FROM ent_boxoffice_ext a 
行 43:                             left join ent_movie b on a.movieid = b.id left join ent_movie_mtime m on m.id=b.id WHERE rank =1 and did = " + did + " order by rank";
行 44:         DataTable table = SqlDataProvider.ExecuteDataTable(ConfigSetting.ConnectionString, strSql);
行 45: 
行 46:         this.rank1.DataSource = table;

源文件: d:\wwwroot\english.entgroup.cn\boxoffice\hk\Office_hk.aspx.cs    行: 44

堆栈跟踪:


[SqlException (0x80131904): 关键字 'order' 附近有语法错误。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3180428
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +332
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4224
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +87
   System.Data.SqlClient.SqlDataReader.get_MetaData() +99
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) +584
   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) +3069
   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) +674
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +202
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +453
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +141
   ent.DataProvider.SqlDataProvider.ExecuteDataTable(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in F:\Projects\ent.DataProvider\SqlDataProvider.cs:1490
   ent.DataProvider.SqlDataProvider.ExecuteDataTable(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in F:\Projects\ent.DataProvider\SqlDataProvider.cs:1459
   ent.DataProvider.SqlDataProvider.ExecuteDataTable(String connectionString, String commandText) in F:\Projects\ent.DataProvider\SqlDataProvider.cs:1439
   Office_hk.Bind() in d:\wwwroot\english.entgroup.cn\boxoffice\hk\Office_hk.aspx.cs:44
   Office_hk.Page_Load(Object sender, EventArgs e) in d:\wwwroot\english.entgroup.cn\boxoffice\hk\Office_hk.aspx.cs:28
   System.Web.UI.Control.OnLoad(EventArgs e) +103
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1381


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