Page 1 of 1

sorting (order of category and products)

Posted: Tue Feb 10, 2009 4:43 am
by rohitsrivastava
Hi,

i am using an dropdown for categories in this dropdown menu all categories are displaying using order by clouse..
on selection of any category their related products are displaying using

CommerceBuilder.Catalog.CatalogNodeCollection nodes = CommerceBuilder.Catalog.CatalogDataSource.LoadForCategory(int.Parse(Request.QueryString["cID"].ToString()), true);
ProductCollection products = new ProductCollection();
foreach (CommerceBuilder.Catalog.CatalogNode node in nodes)
{
if (node.CatalogNodeType == CommerceBuilder.Catalog.CatalogNodeType.Product)
products.Add((Product)node.ChildObject);
}
ProductList.DataSource = products;
ProductList.DataBind();

what we should do to use order by in this code..i want to display all product in specific order.


Regards
Atul khare

Re: sorting (order of category and products)

Posted: Tue Feb 10, 2009 4:58 am
by mazhar
You need to pass an extra parameter in the following statement

Code: Select all

CommerceBuilder.Catalog.CatalogNodeCollection nodes = CommerceBuilder.Catalog.CatalogDataSource.LoadForCategory(2,true);
For example if you want to load products and sort by product name then you need to pass the column Name as below

Code: Select all

CommerceBuilder.Catalog.CatalogNodeCollection nodes = CommerceBuilder.Catalog.CatalogDataSource.LoadForCategory(2,true,"Name");
If you want to sort in descending order then it will LoadForCategory(2,true,"Name DESC");

Re: sorting (order of category and products)

Posted: Tue Feb 10, 2009 7:51 am
by rohitsrivastava
Hi,

Thanks a lot for your immediate help..

Regards
Rohit