PC Review


Reply
Thread Tools Rate Thread

DataTable.Select FilterExpression with Distinct

 
 
Kevin Ross
Guest
Posts: n/a
 
      31st Jul 2003
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select Distinct on a DataTable Doug Bell Microsoft VB .NET 7 2nd May 2007 01:17 PM
Implementing SELECT DISTINCT with DataTable.Select method Andrea Caldarone Microsoft ADO .NET 2 30th Jan 2007 09:28 AM
DataTable.Select filterexpression Kevin Attard Microsoft ASP .NET 2 13th Oct 2006 01:36 PM
SELECT Distinct from DataTable, without using SQL Duncan M Gunn Microsoft ADO .NET 4 15th May 2005 01:38 PM
How do I select distinct rows from a DataTable? Jim H Microsoft C# .NET 2 12th Sep 2004 04:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:20 PM.