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 DataGridViewCom boBoxColumn, 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?
data and a BindingSource between the grid and the dataset.
One of the columns is a DataGridViewCom boBoxColumn, 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?