Using VS2005, on the form is a DataGridView, a typed DataSet containing the
data and a BindingSource between the grid and the dataset.
One of the columns is a DataGridViewComboBoxColumn, doing what it should,
displaying text in the grid while binding to an integer ID field.
I can filter the grid perfectly on the text being displayed for this column,
by using:
BindingSource1.Filter = "TheColName Like 'abc%'"
However when sorting on this column by clicking the header, the grid sorts
on the ID and not the text being displayed in the grid. How do I get around
this?