sum rows

Question

how to sum different columns in a different rows in a dataset...i need to sum quantity .if these are in grid? id product name date quantity 3 pppppppp 27-10-2014 5 4 pppppppp 28-10-2014 6

Khan Abrar Ahmed · Answer

Hi try this var results = from row in lDTSalesOrder group row by row . Field (  product name  ) into grp orderby grp . Key select new { id = grp . Key  Quantity = grp . Sum ( r => r . Field ( Quantity )) };