How to update dataTable2 rows from dataTable1 rows?Update missing,changed rows.
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
dt.Rows.Add(0, "ddd");
dt.Rows.Add(1, "aaa");
dt.Rows.Add(2, "adsd");
dt.Rows.Add(3, "dfdg");
dt.Rows.Add(4, "vdesd");
DataTable dt2 = new DataTable();
dt2.Columns.Add("ID");
dt2.Columns.Add("Name2");
dt2.Rows.Add(0, "223");
dt2.Rows.Add(1, "");
dt2.Rows.Add(2, "ad564sd");
Thanks in advance.
Javeed M ShaikhPosted Apr 8, 2013, 12:38 PM
look into datatable.merge, but you have to tweak your code a little, good example on MSDN:
http://msdn.microsoft.com/en-us/library/system.data.datatable.merge.aspx