development blog for the wicked stuff we encounter

I recently found a way to do a distinct operation on the DataTable class in dotnet 2.0: DataTable products = GetProductList(); DataView dv = new DataView(products); products = dv.ToTable("products", true, new string[] {"ArticleId","ArticleName","Description"}); And the products DataTable will be a distinct list of all products (in this case, one product can belong to two categories as well - so there are duplicate items with different price, attributes etc.).