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

[ABHI_S (Abhi)]

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
   
   
   

Thanks

[NIVED_NAMBIAR (NIVED N)]

Hi @ABHI_S
i am not cleared with ur query

do u need to update third column ?

[ABHI_S (Abhi)]

yes…