I have a dataset MyDs which has a table MyTable. In MyTable I have column Quantity and column
ProductId. What I need to do is iterate through the dataset an check which product ids are repeated and total up the corresponding quantities. I don't know how to check for repeated products id...
I've been stucked for more than a day trying to do this plz help me.

Regards

Noel

You have two basic options. The easiest is to have the database return the data alongside the initial data. You then get two datatables, one for individual data and one for aggregates. If you need something more dynamic on the client then you need to create a secondary table and set the expression property of the columns to point at the first tables rows.

See these links:
 http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression(vs.71).aspx
 and
http://www.ondotnet.com/pub/a/dotnet...pressions.html

--

Joe (Microsoft MVP - XML)