>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.