CHYBA: ProductList-RenderData select count(*) as count from ProductsCategory as PC inner join Products as P on P.pkProducts = PC.fkProducts INNER JOIN VirtualWebsProducts AS VWP on VWP.fkProducts=P.pkProducts and VWP.fkVirtualWebs=@fkVirtualWebs INNER JOIN ProductsPriceList as PPL on PPL.fkProducts = P.pkProducts AND PPL.fkVirtualWebs=@fkVirtualWebs AND fkCurrencyList = @fkCurrencyList AND fkPriceList is null AND PPL.Price > 0 AND PPL.fkProductsVariants is null LEFT JOIN ProductsPriceList as PP2Sort on PP2Sort.fkProducts = P.pkProducts AND PP2Sort.fkVirtualWebs=@fkVirtualWebs AND PP2Sort.fkCurrencyList = @fkCurrencyList AND PP2Sort.fkPriceList =@DealerA AND PP2Sort.Price > 0 AND PP2Sort.fkProductsVariants is null LEFT JOIN TempParamTable as TPT ON TPT.fkProducts=P.pkProducts WHERE PC.fkCategory='34e3dd22-eaad-40e3-8c01-98e68b2a15bb' AND IsActive=1 AND ( (param6360=@paramVal1) ) Invalid column name 'param6360'. 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 WebClient.controls.ProductList.SetSqlCommand(SqlCommand cmd) in C:\Data\Projekty\chytre-dobijeni.cz\WebClient\controls\ProductList.ascx.cs:line 1576
at WebClient.controls.ProductList.RenderData() in C:\Data\Projekty\chytre-dobijeni.cz\WebClient\controls\ProductList.ascx.cs:line 879