How to sum the column values using LINQ

Help Activities
, ,
2

Hi,

How about the following?

image
image637×526 17.2 KB 

dtResult = dt.AsEnumerable.GroupBy(Function(r) r("Number").ToString).Select(Function(g) dtResult.LoadDataRow({g.key,g.Sum(Function(r) r.ItemArray.Skip(1).Sum(Function(o) Double.Parse(o.ToString,System.Globalization.CultureInfo.CreateSpecificCulture("Es-es")))   ).ToString(System.Globalization.CultureInfo.CreateSpecificCulture("ES-es")) },False)).CopyToDataTable

Sample20221102-1.zip (9.8 KB)

BTW, result for 586 is 397435, isn’t it?

Regards,

1 Like