Then let me try
1 Like
as here buddy @VenkatDurbha
I have to use For Reach row activity, then what should i do in the above case?
If we want to use for each row activity you can use add data row activity to add a row in a datatable, but that datatable should not be passed as a input to the for each row loop, i.e., we can pass datarow to NEW datatable and not to the one in for each row loop input…
the reason is when you add data row to the datatable passed as input for each row loop, an error will occur as we iterating through each row by row in a for each row loop,and meanwhile if we add a row while iterating, it will disturb the for each row loop to iterate…
so we can pass only a new datatable to which we can add datarow
but if we use for each loop and a add data row activity with array row as input we wont facing this issue, as we are passing the rows as datatablename.rows explicitly to the for each loop
Cheers @VenkatDurbha
1 Like
buddy check in the add data row activity with array row property whether the number value passed is more than the number of columns in the datatable to which you are passing
and while mentioning the column index make sure you pass from item(0),item(1) that is from 0,1,2… as the column index starts from 0 buddy
Cheers @VenkatDurbha
1 Like
can you please send me an example?.I will be very helpful.
1 Like
sure buddy here you go
ven.zip (8.5 KB)
Cheers @VenkatDurbha
were you able to add now buddy @VenkatDurbha
I can’t able to open the .xaml file.I dont know what is issue. Can you just send me the screenshot.
1 Like
No worries buddy
- Used read range and obtained a variable of type datatable named oudt
And used a for each loop with input like this
Cheers @VenkatDurbha
1 Like
Were you able get now buddy @VenkatDurbha
This gives error…AsEnumerable is not member of System.Data.DataTable,Please guide
check this post @Mayyur
2 Likes