Cannot get sum from Dataview list

Question

Hello everybody, I try to get a list from a dataview containing a sum and grouped by some fields. DataView view = _objManager.ACCOUNTS.DefaultView; // Set RowStateFilter to display the current rows. view.RowStateFilter = DataViewRowState.CurrentRows; var res = ((DataTable)view.Table) .AsEnumerable() .GroupBy(row => new { ID = row.Field long ?>( "ID" ), ELEM = row.Field string >( "ELEM" ) }) .Select(sel => new { NAME = sel.First()[ "NAME" ], ID = sel.First()[ "ID" ], IBAN = sel.First()[ "IBAN" ], BIC = sel.First()[ "BIC" ], INFO = sel.First()[ "INFO" ], AMOUNT= sel.Sum(s => sel.Sum()[ "AMOUNT" ]) //doesn't work }).ToList(); But the sum doesn't compile. Do you have and idea ? Thanks a lot in advance. Eric

Rajesh Gami · Answer

You can write query like AMOUNT= sel.Sum(s => s.Amount) Don't write like AMOUNT= sel.Sum(s => sel.Sum()["AMOUNT"]).

Jayakumar Vinayagam · Answer

Hi, Please try this, it works. var grouped = table.AsEnumerable() .GroupBy(x => new { Id = x.Field ("Id"), Elem = x.Field ("Elem") }) .Select(x => new { Id = x.Key.Id, Name = x.FirstOrDefault().Field ("Name"), IBan = x.FirstOrDefault().Field ("IBan"), Bic = x.FirstOrDefault().Field ("Bic"), Info = x.FirstOrDefault().Field ("Info"), Elem = x.Key.Elem, Amount = x.Sum(y=>y.Field ("Amount")) }) .ToList(); Many thanks

Laxmidhar Sahoo · Answer

Hi In group by clause can not select other than key fields .If select as aggregates. So try the bellow code .or something like this . var res = ((DataTable)view.Table) .AsEnumerable() .GroupBy(row => new { ID = row.Field long ?>( "ID" ), ELEM = row.Field string >( "ELEM" ) }) .Select(sel => new { ID = sel.Key.ID, ELEM = sel.Key.ELEM, AMOUNT= sel.Sum(sel.Field long ?>( "AMOUNT" )) //doesn't work }).ToList(); Thanks and Regards

Ashutosh Gupta · Answer

check this link https://stackoverflow.com/questions/37575198/using-linq-to-groupby-and-sum-datatable

Farhan Ahmed · Answer

https://stackoverflow.com/questions/49493451/grouping-rows-in-a-datatable-by-column-then-summing-the-contents-of-other-colum https://www.codeproject.com/Questions/111761/DataTable-compute-with-group-by https://stackoverflow.com/questions/37575198/using-linq-to-groupby-and-sum-datatable

Darshan Shah · Answer

We can use compute in C# code to achieve this. int total = dsTempData.Compute( "Sum(ColumnName)" , "" );