Add Array to Datatable

[Rajat_Hedaoo]

I have a list of string and I want to add it at the top of a datatable, means at index 0. How can I do this?

[supermanPunch (Arpan)]

Hi @Rajat_Hedaoo ,

Could you maybe try Checking the post below :

Add datarow or arrayRow at specific position in datatable

Hope these steps would help you to resolve this you were almost done, i hope you would have tried to add datarow while looping or while the datatable is been accessed in the middle –if we have the datatable named dt ready –use a INVOKE METHOD like this here you go with a sample xaml invoke.zip (2.3 KB) Cheers @Raju_Balla

[fernando_zuluaga]

Hey

you can add your array like this

yourList.Select(Function(n) cobj(n)).ToArray()

and then swap your row position with this

How to swap two rows in a datatable

Yes @Obee You can swap two rows in a datatable with below code. (one way i have done this like below) DataRow selected_first_row_to_swap= YourDatatable.Rows[index_of_that_row]; // YourDatatable.Rows(0) DataRow selected_second_row_to_swap= YourDatatable.Rows[index_of_that_row]; // YourDatatable.Rows(2) DataRow newRow = YourDatatable.NewRow() DataRow newRow1 = YourDatatable.NewRow() newRow.ItemArray = selected_first_row_to_swap.ItemArray; // copying data newRow1.ItemArray = selected_second_row_t…

Regards

[Rajat_Hedaoo]

Hi @supermanPunch,

How to convert list of string to DataRow object for passing as argument in the invoke method activity which you have used?

Thanks,
Rajat

[supermanPunch (Arpan)]

@Rajat_Hedaoo

How to convert list of string to DataRow object for passing as argument in the invoke method activity which you have used?

@Rajat_Hedaoo ,
Apologies. It seems the workflow only adds an Empty row in the datatable at the required position.

We could add the data by creating a new DataRow variable and assigning the list value to it and then performing the setting up of the row in the first position.

Check the updated workflow below :
invoke.zip (2.8 KB)