Code: Select all
protected void BindProductList()
{
Trace.Write(this.GetType().ToString(), "Begin BindProductList");
ProductList.DataSource = ProductDataSource.NarrowSearch(_FilteredKeywords, this.CategoryId, _ManufacturerId, 0, 0, _PageSize, (_HiddenPageIndex * _PageSize), SortResults.SelectedValue);
ProductList.DataBind();
NoSearchResults.Visible = (_SearchResultCount == 0);
SearchResultsAjaxPanel.Update();
Trace.Write(this.GetType().ToString(), "End BindProductList");
}
Code: Select all
protected void BindProductList()
{
Trace.Write(this.GetType().ToString(), "Begin BindProductList");
string excludeProducts="1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16";//Replace with your own excluded Product Ids
ProductList.DataSource = LoadProducts(excludeProducts); //ProductDataSource.NarrowSearch(_FilteredKeywords, this.CategoryId, _ManufacturerId, 0, 0, _PageSize, (_HiddenPageIndex * _PageSize), SortResults.SelectedValue);
ProductList.DataBind();
NoSearchResults.Visible = (_SearchResultCount == 0);
SearchResultsAjaxPanel.Update();
Trace.Write(this.GetType().ToString(), "End BindProductList");
}
protected List<Product> LoadProducts(string productids)
{
CommerceBuilder.Data.Database database = Token.Instance.Database;
string sql = ("SELECT ProductId FROM ac_Products WHERE ProductId NOT IN (" + productids + ")");//Comma seperated product ids
List<Product> filteredProducts = new List<Product>();
using (System.Data.Common.DbCommand selectCommand = database.GetSqlStringCommand(sql))
{
database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, Token.Instance.StoreId);
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read())
{
int prodId = dr.GetInt32(0);
Product product= ProductDataSource.Load(prodId);
if(product!=null)
filteredProducts.Add(product);
}
}
}
return filteredProducts;
}