System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'AND'.
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.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
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.FormWeeklyLedger.LoadGridData(String employeeId, String dtFrom, String dtTo, String type) in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\FormWeeklyLedger.aspx.cs:line 112
at XReports.XerpReports.FormWeeklyLedger.LoadGridData() in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\FormWeeklyLedger.aspx.cs:line 39
at XReports.XerpReports.FormWeeklyLedger.Page_Load(Object sender, EventArgs e) in D:\Probashi DLO\DLO_RPT\DLORPT\XerpReports\FormWeeklyLedger.aspx.cs:line 21
ClientConnectionId:1a576130-86f7-4ced-9fa1-f5b6f546a977
Error Number:156,State:1,Class:15