Need to compare two table values and save the difference of both tables using asp.net c#

Question

need to compare two table values and save the difference of both tables using asp.net c#

Senthilkumar · Answer

Hi Selvi, Hi, If you have two data tables then public static DataTable CompareTwoDataTable(DataTable dt1, DataTable dt2) { dt1.Merge(dt2); DataTable d3 = dt2.GetChanges(); return d3; } Another way of doing is iterate the datatable and check the each row. If there is any difference then add it into another datatable. //create two dataTables with the same columns DataTable table1 = new DataTable(); DataTable table2 = new DataTable(); table1.Columns.Add(new DataColumn("name", typeof(string))); table1.Columns.Add(new DataColumn("age", typeof(int))); table1.Columns.Add(new DataColumn("born", typeof(DateTime))); //same you do for table2! //then fill them up //create the third table - a clone of table1 DataTable table3 = table1.Clone(); bool found = true; bool notFound = false; foreach (DataRow row1 in table1.Rows) { found = false; notFound = false; foreach (DataRow row2 in table2.Rows) { string item1 = row1[0].ToString(); string item2 = row2[0].ToString(); if (item1 != item2) { found = true; } else if (item1 == item2) { notFound = true; } } if (found == true && notFound == false) { DataRow row3 = table3.NewRow(); row3["name"] = row1[0]; row3["age"] = row1[1]; row3["born"] = row1[2]; table3.Rows.Add(row3); } } For more info: http://social.msdn.microsoft.com/Forums/en/csharpgeneral/thread/1407a809-9551-4646-b74d-3dee3535249c http://www.dotnetperls.com/datatable-compare-rows