Loading default combobox values from a source in a datagrid

11-20-2009 9:52 PM |

How will I be able to load values from a source to a combobox in a datagrid.  Here's the requirement:

a. Load the combobox in a datagrid with the following values (Red, Gree, Blue).  That's doable.

b. From a database query if the query returns 3 rows with Red, Blue, Blue as values.  When the page initially loads, the combobox on the grid should have Red on the 1st row, Blue on the 2nd and 3rd rows.  I'm not sure how this is done.

 Any help will be appreciated.