Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. DataTable dt1 = new DataTable("Table1");
  2. DataTable dt2 = new DataTable("Table2");
  3.  
  4. dt1.Columns.Add("ID", typeof(Int32));
  5. dt1.Columns.Add("Quantity", typeof(Int32));
  6. dt1.Rows.Add(new object[] { 1, 1 });
  7. dt1.Rows.Add(new object[] { 2, 2 });
  8. dt1.Rows.Add(new object[] { 3, 3 });
  9. dt1.Rows.Add(new object[] { 4, 4 });
  10.  
  11. dt2.Columns.Add("ID", typeof(Int32));
  12. dt2.Columns.Add("Quantity", typeof(Int32));
  13. dt2.Rows.Add(new object[] { 1, 100 });
  14. dt2.Rows.Add(new object[] { 3, 100 });
  15. dt2.Rows.Add(new object[] { 4, 100 });
  16.  
  17. dt1.Merge(dt2);
  18.  
  19. var datas = dt1.AsEnumerable()
  20. .GroupBy(r => new { Col1 = r["ID"] })
  21. .Select(g => g.First()["Quantity"] = g.Sum(x => int.Parse(x["Quantity"].ToString())))
  22. .ToList();
  23.  
  24. dt1 = dt1.AsEnumerable().GroupBy(r => new { Col1 = r["ID"] })
  25. .Select(x => x.First()).CopyToDataTable();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement