How to convert type data.table to type IEnumerable

Help
1

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

2

Hi @sushree.suravibuyan

You could try dataTable.Select().ToList().AsEnumerable

image.png786×214 7.22 KB

5 Likes
3

Hello @sushree.suravibuyan,

You could also try the following example. As you can see, you may convert the datatable directly to an IEnumerable type.

Main.xaml (8.5 KB)

2 Likes
4

Thanks @Susana and @acaciomelo for guiding me.

1 Like
5

Just a quick note, since this pops up quite a lot:

A DataTable is not an IEnumerable by itself. Internally, the .AsEnumerable() call on it actually takes the .Rows collection and converts that into an IEnumerable(Of DataRow).

That aside, since RowCollection does implement IEnumerator, you can use a ForEach loop on yourDataTable.Rows or use a ForEachRow activity on yourDataTable variable directly.

1 Like
6

What about the other way around? I have an Ienumerable and I want a datarow (best i think) or data table. I Assume I need to use an assign activity but can’t work out the expression. The Read Row activity spits out an Ienumerable, and when I put it into the “Add data Row” in the “ArrayRow” input to try and build a datatable from it, the data table just gets written to csv as system.Object. I’ve put a couple of days into this and it’s time to ask for help :frowning:

Help.png1073×678 21.4 KB

1 Like
7

Did you ever find a solution? Cause I’m looking for the same thing :slight_smile:

8

@AnniekJ

If you are passing the DataRow variable then you have to pass it to data row option in add data row…
Ref Below
image

  1. If you are passing array then you should pass values in {} this brackets
    Ref Below
    image
    image748×558 14.6 KB

Just in the place of column1 value you have to your value in reference to your data table column