Hi, I would like to simulate a SELECT DISTINCT query, on a DataSet (rather
than going back out to disk).
I have a DataSet with a nicely populated DataTable - how would I go about
adding a DataView that contains _only_ unqiue values of a certain column?
The DataView is to be bound to a DropDownList. I know there's a GROUP clause
that can be used in a RowFilter expression, but I cant find its syntax.
I've had a quick look for this but found nothing so far... (appologies if
The other method would be iterating through the entire table and inserting
into an array etc, but wouldn't be as clean.
Many thanks for any ideas,