How to put array of data row into a data table?

[Venkatesh_Chowdary (0099)]

thank you.

[Dominic]

@Venkatesh_Chowdary, Refer this,

How to Display DataRow Array

@Derek_Xu, First convert it to datatable using DataRowarray.CopyToDatatable() use Output Datatable → converts datatable to string use this string in writeline SideNote : These steps are already available in our forum (might be in different threads). Search if you wanna know more Regards, Dom

Regards,
Dom

[arivu96 (Arivazhagan A)]

Hi @Venkatesh_Chowdary ,

Use add data row to add the data array into datatable.

Use for each to loop through the array of data row. And add the data into datatable.

Regards,
Arivu

[MAHESH1 (MAHESHKUMAR JV)]

@Venkatesh_Chowdary

Datatable DT=DataRowArray_Variable.CopyToDataTable()

Regards,
Mahesh

[oduzen001 (oguzhan duzen)]

Hello Mahesh,

I want to ask you the opposite. I want to create array of strings for each row in Excel datatable and could not find appropriate post for it. Could you please help ?

Best,

[MAHESH1 (MAHESHKUMAR JV)]

@oduzen001

Read Excel Sheet and store it in a datatable dta

Now create a Variable ABC which is of datatype List(Of List(Of Strings))

ABC = (From p In dta.Select
           Select p.ItemArray.ToList).ToList

p represents each row of datatable dta
and we are converting each row to a list of strings.
So ABC is List of List of strings.

So if you access ABC(0) you will get a list of strings which is of row 0.

Regards,
Mahesh

[AnirudhGoswami]

.copytodatatable() throws error for me

[loginerror (Maciej Kuźmicz)]

Hi @AnirudhGoswami

What is the error when you hover over the blue exclamation mark?