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

在将 nvarchar 值 '2015-05-005' 转换成数据类型 int 时失败。

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

异常详细信息: System.Data.SqlClient.SqlException: 在将 nvarchar 值 '2015-05-005' 转换成数据类型 int 时失败。

源错误:


行 76: 			if (sql != "")
行 77: 			{
行 78: 				using (DataTable dt = SqlHelper.ExecuteTable(SqlHelper.ConnectionString, CommandType.Text, sql))
行 79: 				{
行 80: 					this.DGList.DataSource = dt;

源文件: d:\IeeWeb2014\中国医学物理学杂志\OA\KeySearch.aspx.cs    行: 78

堆栈跟踪:


[SqlException (0x80131904): 在将 nvarchar 值 '2015-05-005' 转换成数据类型 int 时失败。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1754082
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5295874
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +342
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +227
   System.Data.SqlClient.SqlDataReader.Read() +34
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +64
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +148
   System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +315
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +160
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +108
   Samson.Common.SqlHelper.ExecuteTable(String connString, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) +227
   Samson.OAAMagazine.OA.KeySearch.DoDataBind() in d:\IeeWeb2014\中国医学物理学杂志\OA\KeySearch.aspx.cs:78
   Samson.OAAMagazine.OA.KeySearch.Page_Load(Object sender, EventArgs e) in d:\IeeWeb2014\中国医学物理学杂志\OA\KeySearch.aspx.cs:33
   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.34237