我在产品页面上看到此问题，转换失败 [英] I got this issue on on product page, Conversion failed

问题描述

Source: .Net SqlClient Data Provider
Message: Conversion failed when converting the varchar value ' $Version=0' to data type int.
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at DAL.SqlHelper.FillDataset(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters) at DAL.SqlHelper.FillDataset(SqlConnection connection, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters) at DAL.SqlHelper.FillDataset(CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters)

推荐答案

Version = 0'转换为数据类型int. 堆栈跟踪:位于System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常，布尔值 breakConnection) System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResult) System.Data.SqlClient.SqlDataReader.HasMoreRows()(在System.Data.SqlClient.SqlDataReader.ReadInternal( Boolean setTimeout)在System.Data.SqlClient.SqlDataReader.HasMoreRows()处. System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping映射)上的SqlClient.SqlDataReader.Read()在System.Data.Common.DataAdapter.FillFromReader(DataSet数据集，DataTable数据表， String srcTable，DataReaderConta内部数据阅读器， Int32 startRecord， Int32 maxRecords，DataColumn parentChapterColumn， System.Data.Common.DataAdapter.Fill处的对象 parentChapterValue)(数据集dataSet，字符串 srcTable，IDataReader dataReader， Int32 startRecord， Int32 maxRecords)，位于System.Data.Common.DbDataAdapter.FillInternal(DataSet数据集，DataTable []数据表， Int32 maxRecords， Int32 startRecord， Int32 maxRecords，字符串 srcTable，IDbComm和命令，DAL.SqlHelper.FillDataset(SqlConnection连接，SqlTransaction事务，CommandType commandType，字符串 commandText，DataSet dataSet，字符串 [] tableNames，SqlParameter [] commandParameters)位于DAL.SqlHelper.FillDataset(SqlConnection连接，CommandType commandType，字符串 [] tableNames，SqlParameter [] commandParameters)位于DAL.SqlHelper.FillDataset(CommandType commandType，字符串 commandText，数据集dataSet，字符串 [] tableNames，SqlParameter [] commandParameters)

Version=0' to data type int. Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at DAL.SqlHelper.FillDataset(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters) at DAL.SqlHelper.FillDataset(SqlConnection connection, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters) at DAL.SqlHelper.FillDataset(CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters)

它可以告诉您确切的错误.您存储的proc(或查询)正在返回一个字符串，而您的数据提供者正在期望一个int.

It tells you exactly what''s wrong. You''re stored proc (or query) is returning a string, and your dataprovider is expecting an int.

这篇关于我在产品页面上看到此问题，转换失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！