Post
Ask Question

Grouping of Data from DataTable and Assign to GridView

  1. var result = dtTable.AsEnumerable().GroupBy(c => c.Field < string > ("GroupbyField")).Select(g => new  
  2. {  
  3.     GroupbyField = g.Key,  
  4.         SumField1 = g.Sum(c => Convert.ToDecimal(c.Field < string > ("Field1"))).ToString("N0"),  
  5.         SumField2 = g.Sum(c => Convert.ToDecimal(c.Field < string > ("Field2"))).ToString("N0"),  
  6. });  
  7. DataTable dtSummary = new DataTable();  
  8. dtSummary.Columns.Add("Column1");  
  9. dtSummary.Columns.Add("Column2");  
  10. dtSummary.Columns.Add("Column3");  
  11. using(var enumerator = result.GetEnumerator())  
  12. {  
  13.     while (enumerator.MoveNext())  
  14.     {  
  15.         dtSummary.Rows.Add(enumerator.Current.GroupbyField, enumerator.Current.SumField1, enumerator.Current.SumField2);  
  16.     }  
  17. }  
  18. GridView1.DataSource = dtSummary;  
  19. GridView1.DataBind();