System.Exception: Error: Conversion failed when converting the nvarchar value '151.00' to data type int. Server: (local) Source: .Net SqlClient Data Provider ----------------------------------------------- ---> System.Data.SqlClient.SqlException: Conversion failed when converting the nvarchar value '151.00' to data type int. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) 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 SaiDattaPreetham.Data.Manager.DataAccess.ExecDataSet(DataSet ds, String strSQL, CommandType cmdtype, ParamStruct[] parameterArray) in D:\Ddrive\SVN\VEDA_Live\VEDA.Data.Manager\DataAccess.cs:line 481 --- End of inner exception stack trace --- at SaiDattaPreetham.Data.Manager.DataAccess.SQLExceptionHandler(SqlException ex) in D:\Ddrive\SVN\VEDA_Live\VEDA.Data.Manager\DataAccess.cs:line 911 at SaiDattaPreetham.Data.Manager.DataAccess.GenericExceptionHandler(Exception ex) in D:\Ddrive\SVN\VEDA_Live\VEDA.Data.Manager\DataAccess.cs:line 883 at SaiDattaPreetham.Data.Manager.DataAccess.ExecDataSet(DataSet ds, String strSQL, CommandType cmdtype, ParamStruct[] parameterArray) in D:\Ddrive\SVN\VEDA_Live\VEDA.Data.Manager\DataAccess.cs:line 486 at SaiDattaPreetham.Data.Manager.DataAccess.ExecDataSet(String strSQL, CommandType cmdtype, ParamStruct[] parameterArray) in D:\Ddrive\SVN\VEDA_Live\VEDA.Data.Manager\DataAccess.cs:line 464 at SaiDattaPreetham.Business.Logic.SpecialEventDetailBL.SpecialEvent_SelectbySpeEventID() in D:\Ddrive\SVN\VEDA_Live\VEDA.Business.Logic\SpecialEventDetailBL.cs:line 549 at html_SpecialEvent.FillData(String ID) in c:\inetpub\wwwroot\veda\html\SpecialEvent.aspx.cs:line 144