Merge two DataTables

sukumar s

Hi Friends,

I need to merge two datatable into one common datatable in version C# 3.5 version. I tried merge operation like dt1.merge(dt2). But it is appending datatable2 values into bottom of datatable1. But I need like below format.

DataTable1 Column1 Column2 Column3   1        Row1      Row2   2        Row3      Row4  DataTable2 Column4 Column5 Column6   1        Row5      Row6   2        Row7      Row8

Resultant Table should be like

DataTable1 Column1   Column2 Column3    Column5  Column6   1        Row1      Row2   Row5    Row6   2        Row3      Row4   Row7    Row8



Please help me on this...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya11y ago
Hello,

Create one temporary DataTable with all columns of both datatables dt1 & dt2.
DataTable dtTemp = new DataTable();
dtTemp.Columns.Add("Col1", typeof(Int32));
dtTemp.Columns.Add("Col2", typeof (string));
dtTemp.Columns.Add("Col3", typeof (string));
dtTemp.Columns.Add("Col4",typeof(string));
dtTemp.Columns.Add("Col5",typeof(string));
dtTemp.Columns.Add("Col6",typeof(string));

Now Merge both datatables one by one.
dtTemp.Merge(dt1);
dtTemp.Merge(dt2);

Now dtTemp Contains all Columns and Rows of Both DataTables.