populating a dropdown list within a datagrid in C#
I am trying to populate a dropdownlist within a datagrid so that on page load it displays the correct location for an employee and also show all the other locations so that one can edit if need be.
e.g if someone lives in New York..New York should appear as selected and not California which is the first value in the ddl.
the dropdownlist within the datagrid is bound to an SQL query which populates the ddl with all the locations.
I believe I have to use the ItemDataBound property within the Datagrid but am not sure how.
Any help wil be highly appreciated.