DataTable.Select FilterExpression with Distinct

  • Thread starter Thread starter Kevin Ross
  • Start date Start date
K

Kevin Ross

Hi,

I want to do a multiple colomn Distinct query on a dataset
like: SELECT DISTINCT Colomn1, Colomn2, Colomn3 FROM
MyTable

Ik know I can't use a the SQL command Distinct in the
DataTable.Select filterexpression. An alternative would be
the function in:

Q325684 HOW TO: Implement DataSet SELECT DISTINCT Helper
Class in VB
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q325684

But it only works for one colomn, is it possible to do a
multiple distinct? I tried to alter the function in
Q325684 but i'm not getting anywhere. Does anyone have an
answer/solution, maybe a new direction?

Thanx,
Kevin
 
Back
Top