List categories AND records at once...

[Øyvind Isaksen]

Hi!

I have a SQL database with products stored in different categories.
When I click a category, I want to list all the subcategories WITH their
products.

Like this:

SubCategory 1 Name
Product 1
Product 2
Product 3

SubCategory 2 Name
Product 1
Product 2
Product 3

SubCategory 3 Name
Product 1
Product 2
Product 3


How is the "correct" way to do this in asp.net (VB.net)?
Thanks for all tips?

 

[Patrick.O.Ige]

You can easily use a Treeview webcontrol for that just BIND it to the any
datasource of your choice.
e.g Xml,DB etc..
Hope that helps
Patrick