Merge two DataTables

Question

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...

Piyush Pansuriya · Answer

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.