Working on a Requirement where I am using Run query Activity getting error

[mittal.abhishek066]

I am fetching details thru run query activity also getting the output but when i am iterating into for each loop getting error system data table cannot be converted into IEnumerable.

Can anybody give the solution here so that i can able iterating records one by one.

Thanks in Advance !!

[Yoichi]

Hi,

How about to use ForEachRow activity?
OR Use dt.AsEnumerable() as the following?

Regards,

[mittal.abhishek066]

Thanks for replying ,

Yes i am using in for each loop when i am giving my datatable table variable then its giving exception like below mentioned-

Also how I can convert normal data table variable into Enumerable in which my output is stored thru sql query.

[Yoichi]

Hi,

dt.AsEnumerable() returns IEnumerable<DataRow>. Can you try as the above image?

Regards,

[mittal.abhishek066]

Thanks @Yoichi Its working as expected !!

Cheers !!

Happy Automation !!