62,244
社区成员




//定义表结构
DataTable table = new DataTable();
DataColumn c1 = new DataColumn("id");
DataColumn c2 = new DataColumn("cItem", System.Type.GetType("System.String"));
DataColumn c3 = new DataColumn("nMoney", System.Type.GetType("System.Int32"));
DataColumn c4 = new DataColumn("nCount", System.Type.GetType("System.Int32"));
//添加列
table.Columns.Add(c1);
table.Columns.Add(c2);
table.Columns.Add(c3);
table.Columns.Add(c4);
//构造行
DataRow r1 = table.NewRow();
r1[0] = "1";
r1[1] = "训练";
r1[2] = "100";
r1[3] = "1";
//构造行
DataRow r2 = table.NewRow();
r2[0] = "2";
r2[1] = "新手手册";
r2[2] = "300";
r2[3] = "2";
//构造行
DataRow r3 = table.NewRow();
r3[0] = "3";
r3[1] = "训练";
r3[2] = "500";
r3[3] = "2";
//构造行
DataRow r4 = table.NewRow();
r4[0] = "4";
r4[1] = "训练";
r4[2] = "120";
r4[3] = "1";
//添加行
table.Rows.Add(r1);
table.Rows.Add(r2);
table.Rows.Add(r3);
table.Rows.Add(r4);
var test = table.AsEnumerable();
var query =
from p in test
group p by p.Field<string>("cItem") into g
select new { item = g.Key, students = g };
foreach (var g in query)
{
Console.WriteLine("{0}的nMoney={1},nCount={2} ", g.item,
g.students.Sum(w => w.Field<int>("nMoney")),
g.students.Sum(w => w.Field<int>("nCount")));
}
int sum = 0;
foreach(DataRow dr in dt.Rows)
{
sum += int.Prase(dr["累加字段"].ToString());
}