How to map Datatables into Array of Datatable

I’m trying to map several Datatable into an array of Datatable.
( Type = System.Data.Datatable )

Datatable_array(0) = Datatable_a
Datatable_array(1) = Datatable_b
… etc.

but when I run the program I get the error :
Assign: The object reference was not set to an object instance.

Can you tell me where the error is?

thanks a lot



You know the count of datatables

with x as this number:

  • Initialise your Array:

    Datatable_array = New DataTable(x){}

  • Assign each DataTable:

    Datatable_array(0) = Datatable_a
    Datatable_array(1) = Datatable_b

You don’t know the count

Create a List of DataTable, add each DataTable then convert ToArray if needed.

  • Initialise your list:

    Datatable_list = New List(Of DataTable)

  • Either use the following code or use the AddToCollection activity:


  • Then convert to Array:

    Datatable_array = Datatable_list.ToArray


Hey msan
many thanks for this very detailed and easy to understand answer



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.