DataView - RowFilter for unique values
Posted on 2005-04-15
I'm thinking the answer is 'No', but has anyone ever used a DataView's rowfilter property to view unique rows?
Consider a table containing 20 cities and their states ('WI', 'MN', 'IL', etc). Column names are City and State.
If I want to see the indivual states that are represented in the table is there any way to say:
dtState.RowFilter = "Unique State"
Any thoughts on how this might be possible?