Hello everyone, I just want to say thanks for all the replies.

Im creating a search feature against the adventure works DB for tables ProductCategory and Product.

The search result that Im looking for is the Product Category Name will be the header and the Product listing is associated with its proper category name.

This is the first thing that I thought of doing:

   Use nested gridview

   List all the category name first and associate the product that matches the search and if theres any category that's empty just simply hide it.

Is there an easier approach?

hello,

try to use a datalist that retrieves all the categories that matches the search result. add a GridView Control to the ItemTemplate of the Datalist that displays the Products of a specific category and at the same matches the search. the HTml code will be something like this:

<Datalist ......................>
<ItemTemplate>
<asp:Label ID="CategoryName".....................></Label>
<asp:GridView ID="Products"........................></GridView>
</ItemTemplate>
</Datalist>