DataTable Merge 合併

DataTable Merge 合併

DataTable dt = new DataTable();
 
DataTable dt2 = new DataTable();
 
DataTable dt3 = new DataTable();
 
 
 
dt.PrimaryKey = new DataColumn[] { dt.Columns["oid"] }; //設定PrimaryKey可以去除重覆
 
dt.Merge(dt2,true);
 
dt.Merge(dt3,true);

Ref URL: https://msdn.microsoft.com/zh-tw/library/system.data.datatable.merge%28v=vs.110%29.aspx