Hello Sylvain,

In addition to Bonnie's suggestion, look at the help topics for DataTable.Select -- as long as you're using a simple WHERE-ish filter command, this will prevent you from having to create a dataview or "scan" the datatable in its entirety.

Hope that helps, too
---J

>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