List categories AND records at once...

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?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

"yvind Isaksen" <oyvind@.webressurs.no> wrote in message
news:OrLrbBm0FHA.2792@.tk2msftngp13.phx.gbl...
> 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?
>