I’m facing one problem, since there are thousands of entries, nested for each are taking a lot of time. Hence, I would like to use either a linq query or any other update query to get the current row index without using for each.
- Filter datatable columns B,C,D as FG, AA, 10 - on row index 1
- Update datatable columns B,C,D as RL, AA, 10 and RL, AA, 10 (on row index 2 / 3)
- I basically need to update the third column D with Values as attached in the image, but there are like 80,000 entries, need a faster way of doing so