Need to get current row index without using For each and update that cell row

Hi Guys,

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.

  1. Filter datatable columns B,C,D as FG, AA, 10 - on row index 1
  2. Update datatable columns B,C,D as RL, AA, 10 and RL, AA, 10 (on row index 2 / 3)
  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


i am not cleared with ur query

do u need to update third column ?