Sylvain,

AFAIK, there's no DataTable method to do this. You'll have to iterate through the Rows (set a view and sort the view, at least then you'll have like values together).

~~Bonnie


>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