Hello Everyone

I have the following Table

Name State
Rob California
Rob Texas
John California
John Virginia
John Texas
John Nevada
Andrew Texas
Andrew Virginia

So i have this information in a datatable and two combo boxes are used on UI for this table. First combo box has to display the distinct from the "Name" column and second combobox has to show data based on selection in first combobox.
If Name = Rob in first combo box, the second combobox should show California and Texas.

please help.. i tried using datatable.select but i am unable to find the distinct among the results and bind them back.

solved..i used dataview.rowfilter property