Combine 2 Data Table

Question

hello.. need your help! this is my code for mydatagridview(datagvTableGroupQuestion) I want to combine 2 data table (dt1 & dt2) but this 2 data table has their own SortOrder. When I merge dt1 with dt2, the datagridview didn't display properly. they shared same SortOrder column. I hide the row, but still same output come. I want to make the dt1 and dt2 display together propely. hope you guys can help me. Thank you!

Abdul Malek · Answer

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

Madan Shekar · Answer

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