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

Amit Mohanty · Answer

Try This... public DataTable getDiffRecords(DataTable dtDataOne, DataTable dtDataTwo) { DataTable returnTable = new DataTable( "returnTable" ); using (DataSet ds = new DataSet()) { ds.Tables.AddRange( new DataTable[] { dtDataOne.Copy(), dtDataTwo.Copy() }); DataColumn[] firstColumns = new DataColumn[ds.Tables[0].Columns.Count]; for ( int i = 0; i { firstColumns[i] = ds.Tables[0].Columns[i]; } DataColumn[] secondColumns = new DataColumn[ds.Tables[1].Columns.Count]; for ( int i = 0; i { secondColumns[i] = ds.Tables[1].Columns[i]; } DataRelation r1 = new DataRelation( string .Empty, firstColumns, secondColumns, false ); ds.Relations.Add(r1); DataRelation r2 = new DataRelation( string .Empty, secondColumns, firstColumns, false ); ds.Relations.Add(r2); for ( int i = 0; i { returnTable.Columns.Add(dtDataOne.Columns[i].ColumnName, dtDataOne.Columns[i].DataType); } returnTable.BeginLoadData(); foreach (DataRow parentrow in ds.Tables[0].Rows) { DataRow[] childrows = parentrow.GetChildRows(r1); if (childrows == null || childrows.Length == 0) returnTable.LoadDataRow(parentrow.ItemArray, true ); } foreach (DataRow parentrow in ds.Tables[1].Rows) { DataRow[] childrows = parentrow.GetChildRows(r2); if (childrows == null || childrows.Length == 0) returnTable.LoadDataRow(parentrow.ItemArray, true ); } returnTable.EndLoadData(); } return returnTable; }

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

Answers (2)