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

')' 附近有语法错误。

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

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

源错误:


行 124:
行 125:        string sqlGetIDs = "select " + idColumnName + " FROM " + tableName + " " + sqlWhere + " " + sqlOrderBy;
行 126:        System.Data.DataTable dtIDs = Web.WebSite.Data.DBBase.ExcuteSelectReturnDataTable(sqlGetIDs);
行 127:        string ids = Common.GetIDsFromTable(dtIDs, pageSize, pageIndex);
行 128:        string sqlGetResult = "select * FROM " + tableName + " where " + idColumnName + " in (" + ids + ") " + sqlOrderBy;

源文件: e:\web\www.bjhrbx.cn\UserControl\ListBinder2.ascx.cs    行: 126

堆栈跟踪:


[SqlException (0x80131904): ')' 附近有语法错误。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3331296
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4289
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
   System.Data.SqlClient.SqlDataReader.get_MetaData() +101
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
   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) +3392
   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) +725
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +465
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +147
   Web.WebSite.Data.DBBase.ExcuteSelectReturnDataTable(String SelectStr, CommandType type, SqlParameter[] pars) in Z:\1097edit\Data\DBBase.cs:322
   Web.WebSite.Data.DBBase.ExcuteSelectReturnDataTable(String SelectStr) in Z:\1097edit\Data\DBBase.cs:327
   UserControl_ListBinder2.BindMe(Int32 pageSize, String sqlFormat) in e:\web\www.bjhrbx.cn\UserControl\ListBinder2.ascx.cs:126
   ASP.talent_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in e:\web\www.bjhrbx.cn\talent.aspx:254
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +276
   System.Web.UI.Page.Render(HtmlTextWriter writer) +40
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4239


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