>>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.
If it's not broken, fix it until it is.
My Blog