Complex combobox binding?

I have a table with following columns: 1)Category_id 2)SubCategory_id (Primary Key) 3)Category_Name I have a textbox displaying category name for subCategory How do I display the parent category in another dropdown.I should also be able to change value(selection from combo).Can it be done by binding the controls. EG. Data CID SubCID Name =============== 1 1 A 1 2 B 1 3 C 2 4 D 3 5 E Please answer this. Thanx for previous answers.

Loader.
Up arrow icon