Grouping in Dataview

[Mr Sam]

I have a Sales Table with the following fields: CustCode, ProdCode, Units, Price, Value I fetch this data in a datatable with all fields. now I want to make a dataview on that datatable with the following fields ProdCode, Sum(Units) as units, Price, Sum(Value) As Value means it contains data on product level. is it possible to make a dataview with this grouping functionality. Bye :rose:

Bye

[umseker]

it would be better using SQL + Group By but if this is not solution try this one HOW TO: Implement a DataSet GROUP BY Helper Class in Visual C# .NET[^]

UMS