C#用DataTable实现Groupby

DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("name", typeof(string)), 
                                                   new DataColumn("score", typeof(int)) });

            dt.Rows.Add(new object[] { "张三", 1 });
            dt.Rows.Add(new object[] { "张三", 4 });
            dt.Rows.Add(new object[] { "李四", 100 });
            dt.Rows.Add(new object[] { "李四", 90 });
            dt.Rows.Add(new object[] { "王五", 77 });

            DataTable dtLwolf = dt.Clone();

            for (int i = 0; i < dt.Rows.Count; )
            {
                DataRow dr = dtLwolf.NewRow();
                string name = dt.Rows[i]["name"].ToString();
                dr["name"] = name;

                int score = 0;
        //内层也是循环同一个表，当遇到不同的name时跳出内层循环
                for (; i < dt.Rows.Count; )
                {
                    if (name == dt.Rows[i]["name"].ToString())
                    {
                        score += Convert.ToInt32(dt.Rows[i]["score"]);
                        dr["score"] = score;
                        i++;
                    }
                    else
                    {
                        break;
                    }
                }
                dtLwolf.Rows.Add(dr);
            }

 

 

 

 

 

 

 

 

    DataTable dtName = dt.DefaultView.ToTable(true, "name");
            for (int i = 0; i < dtName.Rows.Count; i++)
            {
                DataRow[] rows = dt.Select("name='" + dtName.Rows[i][0] + "'");
                //temp用来存储筛选出来的数据
                DataTable temp = dtLwolf.Clone();
                foreach (DataRow row in rows)
                {
                    temp.Rows.Add(row.ItemArray);
                }

                DataRow dr = dtLwolf.NewRow();
                dr[0] = dtName.Rows[i][0].ToString();
                dr[1] = temp.Compute("sum(score)", "");
                dtLwolf.Rows.Add(dr);
            }

 

•