1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| 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"]) //ne marche pas
}).ToList(); |
Partager