program for cascading combo box in asp.net

Question

There are two tables

in 
suppose we choose one value in the combobox1 it must affect the second combobox2 for getting corresponding results related to combobox1..

ex: choose: car means it will show list of cars

        choose:bike means it will show list of bike