Linq Objects Group By &和 [英] Linq Objects Group By & Sum

问题描述

我有一个包含否"和总计"列的数据表.我想带回每个否"的总计"列的总和.我已经尝试了以下方法，但是由于我在语法上遇到了一些错误.

I have a datatable with a column "No" and "Total" column. I'd like to bring back the sum of the "Total" column for each "No". I've tried the below, but I'm getting several errors as I'm struggling with the syntax.

var Values =
        (from data in DtSet.Tables["tblDetails"].AsEnumerable()
         group data by data.Field<"No">
         select new
         {
             name_1 = data.Field<double>("No"),
             name_2 = data.Field<double>("Total"),
         }
         );   

推荐答案

这将为您提供 name_2 属性中 Total 字段的总和，并分组 No 在 name_1 属性中(我认为您需要在这里更好地命名)

This will give you sum of Total fields in name_2 property, and grouping No in name_1 property (I think you need better naming here)

var Values = from row in DtSet.Tables["tblDetails"].AsEnumerable()
             group row by row.Field<double>("No") into g
             select new
             {
                 name_1 = g.Key,
                 name_2 = g.Sum(r => r.Field<double>("Total"))
             };

请考虑名称 No 和 TotalSum.

这篇关于Linq Objects Group By &和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！