In the DataTbale i want to check the "First Column" is null or empty and then if the Fisrt column some rows are empty, copy the "Second Column" col data as same in "Fisrt Collumn"

[krishnapriya_Anu]

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:

[rlgandu (Rajyalakshmi Gandu)]

@krishnapriya_Anu

dt.AsEnumerable().Where(Function(row) String.IsNullOrWhiteSpace(row(“First Column”).ToString())).ToList().ForEach(Sub(row) row(“First Column”) = row(“Second Column”))

[krishnapriya_Anu]

@rlgandu
Hi
Can plz explain it. ?

[lrtetala (Lakshman Reddy)]

Hi @krishnapriya_Anu

You can simply try this

I/P:

O/P:

I hope you understand!!