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 Row8Please help me on this...