var result = from r in tbT.AsEnumerable()
group r by new { Group = r["loginid"]} into g
select new
{
Group = g.Key.Group,
Sum = g.Sum(x => Convert.ToDecimal(x["tradenum"]))
};
foreach (var r in result)
{
Console.WriteLine("\r\n Group {0}, Sum {1}", r.Group, r.Sum);
}
group r by new { Group = r["loginid"]} into g
select new
{
Group = g.Key.Group,
Sum = g.Sum(x => Convert.ToDecimal(x["tradenum"]))
};
foreach (var r in result)
{
Console.WriteLine("\r\n Group {0}, Sum {1}", r.Group, r.Sum);
}