如何获取数据表的SUM值 [英] How to get data table SUM value
问题描述
我无法理解如何在数据表中获取总和值。我尝试了很多方法。但没有奏效。
I cant understand how to get sum value in a data table. I tried many ways. but not worked.
dtFabricItem = dtFabricItem.AsEnumerable()
.GroupBy(r => new
{
Col1 = r["ItemId"],
Col2 = r["intColourId"]
,
Col3 = r["QualityReferenceNo"],
Col4 = r["strSupplierColour"],
Col5 = r["StrLabDipRefNo"],
Col6 = r["strUnitName"],
Col7 = r["decSuggestedQtyToBookYrd"],
Col8 = r["strItemName"],
Col9 = r["decPurchaseRate"]
})
.Select(g => g.First())
.CopyToDataTable();
我尝试过:
dtFabricItem = dtFabricItem.AsEnumerable()
.GroupBy(r => new
{
ItemId = r.Field< int>(ItemId),
intColourId = r.Field< int>( intColourId),
QualityReferenceNo = r.Field< string>(QualityReferenceNo),
strSupplierColour = r.Field< string>(strSupplierColour),
StrLabDipRefNo = r.Field< string>(StrLabDipRefNo),
strUnitName = r.Field< string>(strUnitName),
})
。选择(grp => new
{
name = grp.Key.ItemId ,
州= grp.Key.intColourId,
sum = grp.Sum(金额)
})
.OrderBy(o => o.state)
.ToList();
What I have tried:
dtFabricItem = dtFabricItem.AsEnumerable()
.GroupBy(r => new
{
ItemId = r.Field<int>("ItemId"),
intColourId = r.Field<int>("intColourId"),
QualityReferenceNo = r.Field<string>("QualityReferenceNo"),
strSupplierColour = r.Field<string>("strSupplierColour"),
StrLabDipRefNo = r.Field<string>("StrLabDipRefNo"),
strUnitName = r.Field<string>("strUnitName"),
})
.Select(grp => new
{
name = grp.Key.ItemId,
state = grp.Key.intColourId,
sum = grp.Sum("Amount")
})
.OrderBy(o => o.state)
.ToList();
推荐答案
您好,
参考: 多个分组和Sum LINQ
谢谢
Hello ,
Refer : Multiple group by and Sum LINQ
Thanks
这篇关于如何获取数据表的SUM值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!