hi all,

I have a dataset that returns me a list of products together with their corresponding categories. I have to display those products by grouping them under the category in which they fall.
Actually i'm looping on each row until I encounter a new categoryId, then I would display the products list (like classic ASP), but if there is another alternative to do this then it would be a lot easier...
My query is: Is there a way using ASP.Net or even through ADO.Net or even using .Net controls that can allow me to display these records in such a manner without having to loop on them?

Any help welcomed.
thanx.