How to iterate for this table structure?

database

#1

I have database with this structure:

aaaa

I want to iterate for this table after find in rows “INDEX”. So I want get value “A” , “B”, “C”.
After that I want value right “A”, “B”, “C”. How I can do this?


#2

using For each Row activity and fetch the value by row(“Column Name”)


#3

And I got “System.Data.DataRow”


#4

@Katarzyna_Jan Inside the for each row use get row item than you can get column values


#5

row(“Column Name”).ToString where .ToString converts into a string.


#6

I don’t get it. I don’t know how to do this.


#7

Hi @Katarzyna_Jan

How to make it work.

  1. Read range in the range of your choosing. Include headers.
  2. Iterate through rows of the resulting DataTable and process them