Automatically make .trim () on a datatable in all rows and columns

[ppr (Peter Preuss)]

have a look here:

Delete unwanted spaces in all cells in Datatable

@soorya_prasad as an alternate can be done with linq Assign: dtCorrected= yourDatatbleVar.Clone Assing: dtCorrected = (From r In dtData.AsEnumerable Select ia = r.ItemArray.toList Select ic = ia.ConvertAll(Function (e) e.ToString.Trim.Replace(" “,”")).toArray() Select dtCorrected.Rows.Add(ic)).CopyToDataTable()

in your case:
(From r In dtData.AsEnumerable
Select ia = r.ItemArray.toList
Select ic = ia.ConvertAll(Function (e) e.ToString.Trim()).toArray()
Select dtCorrected.Rows.Add(ic)).CopyToDataTable()

or

(From r In dtData.AsEnumerable
Select rac = r.ItemArray.Select(Function (x) x.toString.Trim).toArray
Select dtCorrected.Rows.Add(rac)).CopyToDataTable()