I am having a data table :
Now if I use Lookup Data Table on ROLLNO column for value 1 it gives me index 0.
What I want is to get the index of row where ROLLNO=1 and NAME=‘XY’
Any suggestions would be really helpful.
Hope we have this datatable ready named dt
—pass this variable dt as input to FOREACH ROW activity and inside that loop use a IF condition like this
row(0).ToString.Equals(“1”) AND row(1).ToStrung.Equals(“XY”)
If true it will go to Then part where we can get the index of that row like this
int_index = dt.Rows.IndexOf(row)
Where int_index is a variable of type int32
Another out of context question. I have a datarow variable var_Data_Row. Is it possible to assign values directly to this variable. If yes, then how.
not to a datarow
but to a specific position that (is specific column) in that datarow
datarowVariable(columnindex) = "yourvalue"
where columnindex starts from 0 for the first column
datarowVariable(“columnname”) = "yourvalue"
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.