sorting (order of category and products)

[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

[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");

[rohitsrivastava]

Hi,

Thanks a lot for your immediate help..

Regards
Rohit