110,534
社区成员
发帖
与我相关
我的任务
分享
sum_num = g.Sum(r => r.Field<Double?>("Num")??0);
sum_num = g.Sum(r => Convert.ToInt32(r.Field<Double?>("Num")??0);
sum_num = g.Sum(r => Convert.ToInt32(r.Field<Double?>("Num").GetValueOrDefault(0)))
var result = from row in mTable.AsEnumerable()
group row by new
{
title = row.Field<string>("Title"),
module = row.Field<string>("Module")
} into g
select new
{
Title = g.Key.title,
Module = g.Key.module,
sum_num = g.Sum(r => Convert.ToInt32(r.Field<string>("Num")))
};