System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '{'. Incorrect syntax near the keyword 'and'. 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.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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Nevoweb.DNN.NBrightBuy.Components.SqlDataProvider.SqlDataProvider.GetList(Int32 portalId, Int32 moduleId, String typeCode, String sqlSearchFilter, String sqlOrderBy, Int32 returnLimit, Int32 pageNumber, Int32 pageSize, Int32 recordCount, String typeCodeLang, String lang) at Nevoweb.DNN.NBrightBuy.Components.NBrightBuyController.GetList(Int32 portalId, Int32 moduleId, String typeCode, String sqlSearchFilter, String sqlOrderBy, Int32 returnLimit, Int32 pageNumber, Int32 pageSize, Int32 recordCount, String typeCodeLang, String lang) at Nevoweb.DNN.NBrightBuy.Components.NBrightBuyController.GetDataList(Int32 portalId, Int32 moduleId, String entityTypeCode, String entityTypeCodeLang, String cultureCode, String strFilters, String strOrderBy, Boolean debugMode, String selUserId, Int32 returnLimit, Int32 pageNumber, Int32 pageSize, Int32 recordCount) at Nevoweb.DNN.NBrightBuy.Components.Products.ProductFunctions.ProductAjaxViewList(NBrightInfo ajaxInfo, String pagemid, String page, Boolean firstRender) ClientConnectionId:317ff825-613e-42a1-8baa-41cf9c140249 Error Number:102,State:1,Class:15