How get unique rows using RowFilter

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

I've a table myTable with the columns City and Address. I
need a view containing the unique values of City. I've
defined the view as DataView myView = new DataView
(myTable). What must I specify in the RowFilter to get the
unique cities? I've tried the keywords distinct and
unieque, but the gave an error.

Another question: Mine view has now the fields of the
table. Is there also a possibility to get only the City-
column in the view?

Thans in advance.
Edward
 
Back
Top