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

')' 附近有语法错误。

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

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

源错误:


行 177:        {
行 178:            int count = 0;
行 179:            Atltest.BLL.ProSortBLL.Select("ParentId=" + sort1.Id + " and Id in (" + strManuSortId + ")", out count);
行 180:            if (count > 0)
行 181:            {

源文件: f:\usr\localuser\byw5921250001\Manufacturer\ProductManu.aspx.cs    行: 179

堆栈跟踪:


[SqlException (0x80131904): ')' 附近有语法错误。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61
   System.Data.SqlClient.SqlDataReader.get_MetaData() +90
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1406
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +149
   JwhCommonClass.DBHelperSQL.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in E:\02办公文件\06公司网站\修改\JwhCommonClass\DBHelperSQL.cs:410
   JwhCommonClass.DBHelperSQL.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in E:\02办公文件\06公司网站\修改\JwhCommonClass\DBHelperSQL.cs:383
   JwhCommonClass.DBHelperSQL.ExecuteScalar(String connectionString, CommandType commandType, String commandText) in E:\02办公文件\06公司网站\修改\JwhCommonClass\DBHelperSQL.cs:375
   Atltest.DAL.ProSortDAL.Select(String strWhere, Int32& recordCount) in E:\02办公文件\06公司网站\修改\Atltest_5.0\Atltest.DAL\ProSortDAL.cs:531
   Atltest.BLL.ProSortBLL.Select(String strWhere, Int32& recordCount) in E:\02办公文件\06公司网站\修改\Atltest_5.0\Atltest.BLL\ProSortBLL.cs:433
   Manufacturer_ProductManu.rptMenuSort1_DataBind() in f:\usr\localuser\byw5921250001\Manufacturer\ProductManu.aspx.cs:179
   Manufacturer_ProductManu.Page_Load(Object sender, EventArgs e) in f:\usr\localuser\byw5921250001\Manufacturer\ProductManu.aspx.cs:96
   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