How to transform DataRow to DataTable

[sfranzen (Steven Franzen)]

This issue is still live and easy to reproduce, at least for me. I have the same thing, with this namespace and also with DataRowExtensions; in fact they do not automatically get imported or even pop up when I start typing System.Data into the Imports field.

Interestingly enough all the functions do work; the validation warning icon will disappear once you have the syntax correct, you just have to manage without the nice intellisense prompt.

[andrzej.kniola (Andrzej Knioła)]

@sfranzen

in fact they do not automatically get imported or even pop up when I start typing System.Data into the Imports field

Just as a sidenote - System.Data.DataSetExtensions is the library file name. Methods that it contains actually are in System.Data namespace (which is already present by default), so there’s nothing to add from Imports panel as it’s already there.
This is what might actually be confusing the Studio, as it’s not adding a namespace, it’s extending it.

@sfranzen

Interestingly enough all the functions do work; the validation warning icon will disappear once you have the syntax correct, you just have to manage without the nice intellisense prompt.

Indeed, that’s why I suggested just typing it in. For me Intellisense catches on after using it and restarting the Studio - seems it doesn’t support hot-reload.
If it would not be working at all, you can also check directly in the xaml for assembly reference to that dll (and add it manually if needed).

[sfranzen (Steven Franzen)]

@andrzej.kniola

This is what might actually be confusing the Studio, as it’s not adding a namespace, it’s extending it.

Good point, I forgot about this and I think you’re right. This must be the crucial difference between these extensions and others, like those in System.Linq, that work just fine out of the box.

[FlpVsg (Felipe Quintanilha)]

I was facing the same problem as described above.
But “.ItemArray” did the trick.
Thanks!

[cacafundi (J.G.)]

Hi folks,

i have a problem adding rows to a datatable, this is my flow:

and this is the error that returns:

please could you tell me what i doing wrong?

thanks to all!!.

[tdhaene (tom Dhaene)]

Invoke ImportRow should solve this

[cacafundi (J.G.)]

Hi tdhaene,

thanks!! , do you mean inside for each row? or is elsewhere.

test_ssrr.zip (15.1 KB)

thanks!!, BR

[tdhaene (tom Dhaene)]

Inside For each row

[cacafundi (J.G.)]

Hi tdhaene,

first thanks for your advices, i tried to put invoke method but get a new error:

thanks!! BR.

[tdhaene (tom Dhaene)]

Did you add in parameters: type datarow, value row

[cacafundi (J.G.)]

Hi folks,

thanks thhaene!! works great!!

thanks!! BR.

[Akshay_patil]

hello vaidya,
i have 4 rows of data in my excel, I want to create a separate excel for each row.

i tried using add data row activity, but not able to convert data row into the data table.