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.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at RunQuery.SQLQuery.ReturnString(String query) in D:\Probashi DLO\DLO_RPT\DLORPT\App_Code\RunQuery.cs:line 47 at XReports.XerpReports.EmployeeLedger.LoadGridData(String employeeId, String dtFrom, String dtTo, String type) in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\EmployeeLedger.aspx.cs:line 117 at XReports.XerpReports.EmployeeLedger.LoadGridData() in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\EmployeeLedger.aspx.cs:line 39 at XReports.XerpReports.EmployeeLedger.Page_Load(Object sender, EventArgs e) in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\EmployeeLedger.aspx.cs:line 21 ClientConnectionId:e70fd2d7-1b7a-40e3-8513-fa932707a386 Error Number:242,State:3,Class:16