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

将 nvarchar 值 'w9p0j6Zl' 转换为数据类型为 int 的列时发生语法错误。

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

异常详细信息: System.Data.SqlClient.SqlException: 将 nvarchar 值 'w9p0j6Zl' 转换为数据类型为 int 的列时发生语法错误。

源错误:


行 95:             ds = new DataSet();
行 96:             this.myadapter = new SqlDataAdapter(tempStrSQL, this.myconn);
行 97:             this.myadapter.Fill(ds, tableName);
行 98: 
行 99:             return ds;

源文件: d:\wwwroot\hengchunyanglao\wwwroot\App_Code\BasicPage.cs    行: 97

堆栈跟踪:


[SqlException (0x80131904): 将 nvarchar 值 'w9p0j6Zl' 转换为数据类型为 int 的列时发生语法错误。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2585906
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039670
   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.TryHasMoreRows(Boolean& moreRows) +242
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +275
   System.Data.SqlClient.SqlDataReader.Read() +35
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +216
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +201
   System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +422
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +219
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +87
   basic.BasicPage.SelectDataBase(String tableName, String tempStrSQL) in d:\wwwroot\hengchunyanglao\wwwroot\App_Code\BasicPage.cs:97
   NewsDetail.showpinlun() in d:\wwwroot\hengchunyanglao\wwwroot\NewsDetail.aspx.cs:147
   NewsDetail.Page_Load(Object sender, EventArgs e) in d:\wwwroot\hengchunyanglao\wwwroot\NewsDetail.aspx.cs:58
   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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


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