How to convert DataTable to IEnumerable

[Klim (Vladislav)]

I was just wondering. If DataTable is an object is there a way to use it in ForEach control flow as a sort of collection?
And if yes, how do I convert DataTable to such iterable object?

Many thanks,

[Susana (Susana González Cacheiro)]

Hello @Klim

You can use For Each Row Activity or For Each Activity changing TypeArgument property:

Activities

Using for each loop in DataTable rows collection

P Szyk August 03, 2016 12:37 ANSWERED I try to use for each loop to go thru DataTable rows, but despite to change variable type to System.Data.DataRow I still getting error that i can’t convert System.Data.DataTable.Rows to an IEnumerable Collection. I try to change DataTable.Rows to list or array but still doesn’t work.

Regards,
Susana

[Klim (Vladislav)]

Hi Susana,
thanks for your response! yes, I know about For Each Row and it works with an object DataTable just fine. But I was wondering is there a chance to convert a DataTable into enumerable / iterator object? just a technical question.

Thanks!

[Susana (Susana González Cacheiro)]

Hi @Klim,

Take a look at this:

How to convert type data.table to type IEnumerable

HI All, I am trying to execute a mysql query and process the data in the form of datatable in a foreach loop. It is giving me error that datatable type can’t be converted into IEnumerable type. Can anyone please help me. Regards Suravi

Regards

[Klim (Vladislav)]

Thanks @Susana! appreciate your response! it was very helpful.