How to select distinct values

[Sylvain Larin]

I have a DataSet filled from a previous query to the database. I need to
get the distinct values from a field in the DataSet. Is there a way to
acheive this without going through the DataTable or by hitting again the
database?

TIA

 

[Patrice]

How could it find without doing one or the other ? My personal preference
would be to select this server side (I would say generally this is because
you want a codification table you could select at the same time resulting in
filling two tables instead of a single table in yur dataset).

If you prefer the other way :
http://support.microsoft.com/default.aspx?scid=kb;en-us;326176





Patrice

 

[Robert Gregory via DotNetMonster.com]

I used the described method by Microsoft...DataSetHelper Class.
Worked fine.