Linq To DataSet 分组求和

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data;

namespace ConsoleApplication2 {     class Program     {         static void Main(string[] args)         {             DataTable dt = new DataTable();             dt.Columns.Add("c1", typeof(int));             dt.Columns.Add("c2", typeof(string));             dt.Columns.Add("c3", typeof(int));

            dt.Rows.Add(1, "技术部", 130);             dt.Rows.Add(2, "产品部", 200);

            dt.Rows.Add(3, "市场部", 130);             dt.Rows.Add(3, "市场部", 30);

            var query = from r in dt.AsEnumerable()                         group r by                         new                         {                             c1 = r.Field<int>("c1"),                             c2 = r.Field<string>("c2")                         }                             into g                             select new                             {                                 g.Key.c1,                                 g.Key.c2,                                 c3 = g.Sum(t => t.Field<int>("c3"))                             };             query.ToList().ForEach(q => Console.WriteLine("{0},{1},{2}", q.c1, q.c2, q.c3));             Console.ReadLine();         }     } }