System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. at System.Data.SqlClient.SqlConnection.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(DataTable[] dataTables, 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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at RunQuery.SQLQuery.ReturnDataTable(String Query) in D:\Probashi DLO\DLO_RPT\DLORPT\App_Code\RunQuery.cs:line 183 at XReports.XerpReports.SalarySheet.LoadGridData(String dtFrom, String dtTo, String type) in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\SalarySheet.aspx.cs:line 104 at XReports.XerpReports.SalarySheet.LoadGridData() in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\SalarySheet.aspx.cs:line 40 at XReports.XerpReports.SalarySheet.Page_Load(Object sender, EventArgs e) in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\SalarySheet.aspx.cs:line 21 ClientConnectionId:a4a9767c-f556-437d-9f68-d2ae6346a764 Error Number:242,State:3,Class:16