I'm using the display value (= Val) of a ComboBox (= Combo1) to filter records in a DataGrid.
The ComboBox is bound to a DataView (= dv) which is itself bound to a DataTable (= dt).
My problem is that there are several occurences of each item and obviously I need to keep only one for filtering purposes.
How can I achieve that?
I've seen something about SQL's "CLAUSE DISTINCT" but how can I use that in a RowFilter expression?
Any help shall be greatly appreciated.