I use datatable.select() return selectdatatable, Then I write selectdatatable.copytoDataTable,but

[sarah]

I use datatable.select() return selectdatatable, Then I write selectdatatable.copytoDataTable,but does not work

exception: the source contains a detached dataRow that can not be copied to the Datatable.

[aksh1yadav (AKSHAY YADAV)]

Hey @sarah

Datatable.select will return you datarow array so to copy them into another datatable you should use ImportRow method.

You can search this on forum.

Copy Row from one DataTable to another

You can use ImportRow method to copy Row from DataTable to DataTable with the same schema A sample reference workflow attached here: ImportRow.xaml (9.9 KB) Regards…!! Aksh

If still any problem will you face then let us know

Regards…!!
Aksh

[Amrita_Mogali]

Hi Sarah,

Datatable.Select() returns an array of datarows, lets assume - dtr_filteredRows. You can use dtr_filteredRows.CopyToDatatable() in the right side of assign activity and use another datatable on the left side of assign.

Hope this helps

Regards,
Amrita

[sarah]

thanks

[Pupina (Sandra)]

Hi Amrita

Can you send me an example. I do not find CopyToDatable only CopyTo.
Thanks.

[ovi (Viorela Preda)]

@Pupina check this please:
CopyToDatatable.xaml (9.6 KB)

@Pupina

I do not find CopyToDatable only CopyTo.

It’s because intellisense doesn’t work for it. But if you just type CopyToDatatable, it will work without error.
More info about this in the link below:

Import namespace System.data.DatasetExtensions

Hi Amrita, System.Data.DataSetExtensions is not a namespace, but an assembly - methods from it are added to namespace System.Data. Might be a coincidence, but when manually typing DataTable newTable = myQuery.CopyToDataTable (where myQuery is IEnumerable) even though Intellisense doesn’t work for it, it added a reference to DataSetExtensions and the workflow works just fine. You could check manually in a text editor if the xaml has the assembly reference to System.Data.DataSetExtensions.dl…

[Pupina (Sandra)]

Thanks Ovi!!! It works!!!

I only need to figure out how to include headers. I read range with addheaders.
I try with clone the original datatable, instead of new datatable.
Can you also help me with this?

[Pupina (Sandra)]

I could do it. It is a simple property. thanks.

[ManuRaj (Manuraj K)]

Well…I am doing everything as you said but still getting “Object reference not set to an instance of an object”. Please help me there.

[SaranyaKishore (Saranya R)]

Hi @ManuRaj,

You can provide new datatable() in the default value of data table variable.
Also refer,

Error: Object reference not set to an instance of an object. This error usually occurs when using a variable with no set value (not initialized) in ADD DATA ROW

Hi, I am getting this error while adding data to dataTable using add data row. I have initialized all variable with “” except array variables. Please suggest. Thanks

[ManuRaj (Manuraj K)]

As I am using DataTable.Select(), it will give an array of datarows. So, assigning new datatable() as default value of data table variable will give error.

[SaranyaKishore (Saranya R)]

Try initializing the DataRow Array.