Cannot get sum from Dataview list

Eric Bryan

6y1.4kLINQ

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajesh Gami6y ago
You can write query like
AMOUNT= sel.Sum(s => s.Amount)
Don't write like AMOUNT= sel.Sum(s => sel.Sum()["AMOUNT"]).
Jayakumar Vinayagam6y ago
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 Sahoo6y ago
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
Darshan Shah6y ago
We can use compute in C# code to achieve this.
int total = dsTempData.Compute("Sum(ColumnName)", "");
Ashutosh Gupta6y ago
check this link
https://stackoverflow.com/questions/37575198/using-linq-to-groupby-and-sum-datatable
Farhan Ahmed6y ago
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