>>Do you also suggest to do this from the database level or after the fact in DataSet? If the later, I would be curious to learn this approach.
>
>It seems all he wants is a count of the unique products. I would try to utilize the code provided by Kevin (I believe it used the .Select method of a DataTable, and there was a parameter to return distinct records) and inspect the rowcount of the filtered resultset.

Thanks, I'll search for this code later.