The problem

I was debugging an old project which used untyped DataSets. The DataTable contained timelisting details of employees. I already filtered the DataTable so I got all records for a certain employee. It still contained about 600 records. I needed to know the distinct dates on which the employee listed his time.

However, the DataTable class doesn’t contain a “SELECT DISTINCT” method. So before I would start doing crazy tricks, I asked my friend Google if he knew anything about the matter.

continue reading…