It seems that a common approach would be to bind a table via a dataset to a
datagridview and then bind columns which contain codes to a combo box. The
code would be the value member; the display member of the combo box would be
a pretty name for the code and would come from another table in the dataset.
And this is easy enough to do.
The difficulty that i have is how to sort this column on the display member
value instead of the value member.
So did I miss something obvious?
My current thinking is to implement an object that also implements
IBindingList. Bind this to the datagridview and have it use the two
datatables as the backing store. In IBindingList.AppySort() this object would
be smart enough to use the display name for the column in question.
Other ideas are welcomed...Chuck
|