In the DataTable i want to check the “First Column” is null or empty and then if the First column some rows are empty, copy the “Second Column” col data as same in “First Column”
DataTable like this
I want a output like this:
In the DataTable i want to check the “First Column” is null or empty and then if the First column some rows are empty, copy the “Second Column” col data as same in “First Column”
DataTable like this
I want a output like this:
dt.AsEnumerable().Where(Function(row) String.IsNullOrWhiteSpace(row(“First Column”).ToString())).ToList().ForEach(Sub(row) row(“First Column”) = row(“Second Column”))
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.