Combine 2 Data Table

hi madan.

 

the problem is dt1 has their own SortOrder column and dt2 also has their own SortOrder column. When I merge it, the datagridview display like figure below.

This is my project API documentation: https://fvdocs.viewpoint.com/Admin_web_topics/APIs/forms_services/r_FormTableGroupResponse.html

solution 1:-

dtAll = new DataTable();

dtAll.Merge(dtOne);

dtAll.Merge(dtTwo);

dtAll.Merge(dtThree);

This technique is useful in a loop where you want to iteratively merge data tables:

DataTable dtAllCountries = new DataTable();

foreach(String strCountry in listCountries)

{

DataTable dtCountry = getData(strCountry); //Some function that returns a data table

dtAllCountries.Merge(dtCountry);

}

solution 2:-

https://www.c-sharpcorner.com/UploadFile/b182bf/how-to-add-two-datatable-in-single-datatable-in-C-Sharp/

https://www.c-sharpcorner.com/UploadFile/0c1bb2/merging-multiple-datatables-into-single-datatable-using-asp/

go through above blogs hope it will help you.. if it helps please mark as answer