Speed up your work using LinQ
“Group” function LINQ Basic
Code:
(From item In dt.AsEnumerable
Group item By col1 = item(“Column1”).ToString.split(“-”,2,stringsplitoptions.none)(1) Into Group
Select dt.Clone.Rows.Add(col1,Group.sum(Function(x) CInt(x(“Column2”).ToString)))).CopyToDataTable
Thanks,