Now I use LINQ as below.
DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("APFNME")= row("APFNME").ToString+"-"+row("APLNME").ToString)
I want to add another column for update
- Update Column FPP by calculate Column FPP /(divide) Column Case
- Update Column APSUM by calculate Column APSUM /(divide) Column Case
Please guide me about it.