LINQ的对象分组依据和放大器;和 [英] Linq Objects Group By & Sum
本文介绍了LINQ的对象分组依据和放大器;和的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一栏否和合计栏的DataTable。我想带回的总计栏的总和为每一个否。我试过下面,但我发现因为我的语法挣扎几个错误。
VAR值=
(从数据DtSet.Tables [tblDetails] AsEnumerable()由data.Field<
组数据;否>
选择新的
{
NAME_1 = data.Field<双>(否),
NAME_2 = data.Field<双>(合计),
}
);
解决方案
这会给你总
在 NAME_2
属性,分组否
域> NAME_1 属性(我想你需要更好的命名此地)
从排VAR值=在DtSet。表[tblDetails] AsEnumerable()$ b。通过row.Field< $ b组排;双>(否),为G
选择新的
{
NAME_1 = g.Key ,
NAME_2 = g.Sum(R = GT; r.Field<双>(合计))
};
考虑有关名称否
和 TotalSum
代替。
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"),
}
);
解决方案
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"))
};
Consider about names No
and TotalSum
instead.
这篇关于LINQ的对象分组依据和放大器;和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文