how to merge Two Datatables to one

Question

Hi All I want to merge Two Datatables to one like this

Jisny Av · Answer

Hi, Please try this code DataTable table1 = new DataTable(); table1.Columns.Add("M1"); table1.Columns.Add("M2"); table1.Columns.Add("M3"); DataRow row1 = table1.NewRow(); row1["M1"] = "100"; row1["M2"] = "120"; row1["M3"] = "322"; table1.Rows.Add(row1); DataRow row2 = table1.NewRow(); row2["M1"] = "200"; row2["M2"] = "350"; row2["M3"] = "542"; table1.Rows.Add(row2); DataRow row3 = table1.NewRow(); row3["M1"] = "300"; row3["M2"] = "120"; row3["M3"] = "544"; table1.Rows.Add(row3); DataTable table2 = new DataTable(); table2.Columns.Add("ID"); table2.Columns.Add("Name_student"); DataRow row11 = table2.NewRow(); row11["ID"] = "1"; row11["Name_student"] = "Mohammed"; table2.Rows.Add(row11); DataRow row22 = table2.NewRow(); row22["ID"] = "2"; row22["Name_student"] = "Ali"; table2.Rows.Add(row22); DataRow row33 = table2.NewRow(); row33["ID"] = "3"; row33["Name_student"] = "Fahe"; table2.Rows.Add(row33); DataTable table3 = new DataTable(); table3.Columns.Add("M1"); table3.Columns.Add("M2"); table3.Columns.Add("M3"); table3.Columns.Add("ID"); table3.Columns.Add("Name_student"); for (int i = 0; i { DataRow row111 = table3.NewRow(); row111["M1"] = table1.Rows[i]["M1"].ToString(); row111["M2"] = table1.Rows[i]["M2"].ToString(); row111["M3"] = table1.Rows[i]["M3"].ToString(); row111["ID"] = table2.Rows[i]["ID"].ToString(); row111["Name_student"] = table2.Rows[i]["Name_student"].ToString(); table3.Rows.Add(row111); }

Ramesh Palaniappan · Answer

Where is Primary Key and Foreign Key relationship between this two tables?

Bikesh Srivastava · Answer

Hi, If you are working on sql create joins.

Midhun Tp · Answer

Hi, i don't think there is any built in method available for that. Just go through below link, it may give you some idea - http://stackoverflow.com/questions/12278978/combining-n-datatables-into-a-single-datatable

lamasat lamasat · Answer

I am sorry like this

Manas Mohapatra · Answer

Use Merge() to add more datatables merge. Try like this: DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); //merging first data table into second data table dt1.Merge(dt2); dt1.AcceptChanges();

Midhun Tp · Answer

Hi, Please check below links- http://www.c-sharpcorner.com/UploadFile/0c1bb2/merging-multiple-datatables-into-single-datatable-using-asp/ http://www.itdeveloperzone.com/2012/04/merge-2-datatables-in-c.html?m=1

how to merge Two Datatables to one

Answers (7)