LinqToDataTable示例1-GroupBySum

•     DataTable dt = new DataTable("temp");
  
      // Definindo os campos da Tabela
      dt.Columns.Add("STATUS", typeof(string));
      dt.Columns.Add("SLA", typeof(string));
      dt.Columns.Add("Qtd", typeof(int));
  

  以下代码是用Linq来实现GroupBy-Sum的效果，直接将Linq结果绑定到GridView上面去。

  var query = from temp in dt.AsEnumerable()
            group temp by new{
              STATUS = temp.Field<string>("STATUS"),
              SLA = temp.Field<string>("SLA")
            } into xGroup
            select new {
              STATUS = xGroup.Key.STATUS,
              SLA = xGroup.Key.SLA,
              QTD = xGroup.Sum(temp => temp.Field<int>("Qtd"))
            };
      GridView1.DataSource = query;
      GridView1.DataBind();