Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string.
Source Error:
Line 52: SqlParameter[] param = new SqlParameter[1]; Line 53: param[0] = new SqlParameter("@Active", "ShowUserEndDefault"); Line 54: DataTable dt = DataAccess.GetDataTable("Manage_News_Events_Insert_Update_Edit_Delete_Show", CommandType.StoredProcedure, param); Line 55: StringBuilder html = new StringBuilder(); Line 56: for (int i = 0; i < dt.Rows.Count; i++)
Source File: d:\NetComm\DIMTS_LATEST_NEW\Default.aspx.cs Line: 54
Stack Trace:
[SqlException (0x80131904): Conversion failed when converting date and/or time from character string.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3321756 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4454 System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +253 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +291 System.Data.SqlClient.SqlDataReader.Read() +42 System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +155 System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +215 System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +406 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +238 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +453 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +141 Netcomm.BaseLibrary.DataAccess.GetDataTable(String ProcNameORQuery, CommandType commandType, SqlParameter[] mySqlParam) +206 _Default.BindNews() in d:\NetComm\DIMTS_LATEST_NEW\Default.aspx.cs:54 _Default.Page_Load(Object sender, EventArgs e) in d:\NetComm\DIMTS_LATEST_NEW\Default.aspx.cs:18 System.Web.UI.Control.OnLoad(EventArgs e) +106 System.Web.UI.Control.LoadRecursive() +68 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785