如何合并Datatable并去重

有时需要重新画一张表格 ，数据需要从其他table中取
如何合并Datatable,并去除重复数据嘞
创建dt1

 DataTable dt1 = new DataTable();
 dt1.Columns.Add("Name ", typeof(string));
 dt1.PrimaryKey = new DataColumn[] { dt1.Columns[0] };
 dt1.Columns.Add("zhong ", typeof(string));
 dt1.Rows.Add("Age ","aa");
 dt1.Rows.Add("Apple","bb");
 dt1.Rows.Add("Orange","cc");
 DataColumn column = new DataColumn("ID", Type.GetType("System.Int32"));
  dt1.Columns.Add(column);
   dt1.Columns["ID"].SetOrdinal(0);
    for (int i = 0; i < dt1.Rows.Count; i++)
    {
 dt1.Rows[i][0] = i + 1;
}
 dt1.PrimaryKey = new DataColumn[] { dt1.Columns[0] };

创建dt2

 DataTable dt2 = new DataTable();
 dt2.Columns.Add("Price ", typeof(decimal));
dt2.PrimaryKey = new DataColumn[] { dt2.Columns[0] };
dt2.Columns.Add("zhong ", typeof(string));
dt2.Rows.Add(10,"aa");
dt2.Rows.Add(6,"bb");
dt2.Rows.Add(7,"cc");
  DataColumn column2 = new DataColumn("ID", Type.GetType("System.Int32"));
    dt2.Columns.Add(column2);
    for (int i = 0; i < dt2.Rows.Count; i++)
    {
 dt2.Rows[i][0] = i + 1;
}
dt2.PrimaryKey = new DataColumn[] { dt2.Columns[0] };

合并

  DataTable dt3 = dt1.Copy();
  dt3.Merge(dt2);