Copy datatable as columns in another datatable

Question

I have a couple of DataTable's and I need to copy them into another DataTable. For example, as you can see in the attached picture, I need to take all the data from the Source Table 1 and copy it in the first 2 columns of the Dest Table, copy Source Table 2 in the next 2 columns, and so on. How can this be easily achieved?

Edit: I have to read several excel files (I am storing each file in a datatable) and I won't know exactly how many source table I will have, so this has to be done dynamically somehow.

Answer 1

Assuming that your source tables have the same structure you can use Table.Copy() to create your dest table and then copy data in loop:

List<DataTable> sourceTables = getYourSourceTablesMethod();
if (sourceTables.Length>0)
{
    DataTable destTable = sourceTables[0].Copy();  

    for (int i = 1; i < sourceTables; i++) 
    {
       foreach (DataRow drow in sourceTables[i].Rows) 
       destTable.Rows.Add(drow.ItemArray);
    }
}

Answer 2

You can use Merge method which provided by framework , for usage and extra info see Microsoft Datatable Merge