DataTable.Select FilterExpression with Distinct

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top