Populate List box beased on combo box

[dkohli]

Hello,
I am new to ASP. I have a list box which gets its values from a table in the database. However I want the values of the list box based on what I click on the combo box as well.

I have a combo box Category:
Web
Store
Phone

I have a category table :
Category Sub Category
Web Online
Store Store1
Store Store2
Store Store3
Phone Phone1

Then I have a list box for subcategory where if I select Store in the category combobox, the list box should automatically get populated by store1, store2, store3

So basically I want to pass the value of the combobox in my where clause in my sql query to the database. How can i do it on the fly?

Any help will be greatly appreciated.
Dkohli

 

[dkohli]

Sorry it is a radio box and not a combo box.