行列汇总

dt.Columns.Add("s1", typeof(System.Int32));
dt.Columns.Add("s2", typeof(System.Int32));
dt.Rows.Add(new object[] { 2, 30});
dt.Rows.Add(new object[] {10, 20});
DataView dv = new DataView(dt);
dv.AllowNew = false;
this.dataGrid1.DataSource = dv;
// 行汇总
object sum1 = dt.Compute("SUM(S1)", "");
object sum2 = dt.Compute("SUM(S2)", "");
dt.Rows.Add(new object[] {sum1, sum2});
// 列汇总
DataColumn dc = dt.Columns.Add("TOTAL", typeof(System.Int32));
dc.Expression = "S1+S2";