Unable to increment the row within for loop, displaying integer cannot be converted to system.datarow

Help Studio
, ,
1

i am trying to loop a data table and read the first row value for a certain column, if the column value satisfies the condition, need to check a diff condition for the same column in next row, but i am unable to increment the row number.

Any help would be appreciated on this.

errorss
errorss772×660 18.8 KB

2

row is not an index. It’s the actual datarow (which is a datatype). So if you have a column named City then you’d get it by doing row(“City”).ToString

If you want the index, you have to put a variable into the index property of the For Each Row activity.

But you don’t increment the row manually. The For Each Row does that for you, it loops row by row.