DataTable: Selecting DISTINCT data with dotnet 2.0
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.).