for (int i = 0; i < dt1.Rows.Count; i++)
{
//用id作為主鍵來確認兩個表中的重複數據
DataRow[] c = dt2.Select("id = '" + dt1.Rows[i]["id"] + "'");
if (c.Length > 0)
{
//如果這條紀錄在dt2裡有那麼就不要這條
dt1.Rows.RemoveAt(i);
}
}
dt1.AcceptChanges();