DataTable数据对比

 public static void DTS()
        {
            Stopwatch sw = new Stopwatch();

            DataTable dt1 = new DataTable();
            dt1.Columns.Add("商品名称");
            dt1.Columns.Add("库存数量");
           // dt1.Columns.Add("创建日期", typeof(DateTime));
            DataTable dt2 = new DataTable();
            dt2.Columns.Add("商品名称");
            dt2.Columns.Add("库存数量");

            List<string> lstName = new List<string>() { "原贝","218原牛","大辣","238初乳片","1斤"};

            Random r = new Random();
            dt1.Rows.Add("原贝", 100);
            dt1.Rows.Add("酸酪", 200);
            dt1.Rows.Add("218原牛", 300);
            dt2.Rows.Add("原贝", 100);
            dt2.Rows.Add("218原牛", 400);
            dt2.Rows.Add("1斤", 500);

            
            DataColumn dc = new DataColumn("创建日期", typeof(DateTime));
            dc.DefaultValue = DateTime.Now;
            dc.AllowDBNull = false;
           // dt2.Columns.Add(dc);
            for (int i = 1; i < 100000; i++)
            {
                dt1.Rows.Add("商品"+i, r.Next(100));
                dt2.Rows.Add("商品" + i, r.Next(100));
            }
            sw.Start();
            //新表中有，老表中没有的
            var changePrint = dt2.AsEnumerable().Except(dt1.AsEnumerable(), DataRowComparer.Default);//.ToArray().CopyToDataTable();
            sw.Stop();

            //老表串有，新表中没有
            //var newSave= dt1.AsEnumerable().Except(twoDtHaveName.ToArray().Cop, DataRowComparer.Default);
            var tog = dt1.AsEnumerable().Union(dt2.AsEnumerable(), DataRowComparer.Default);
            var srcDtTwoHave = (from a in dt1.AsEnumerable() where (from b in dt2.AsEnumerable() select b.Field<string>("商品名称")).Contains(a.Field<string>("商品名称")) select a);

            var newSave = dt1.AsEnumerable().Except(srcDtTwoHave, DataRowComparer.Default).Union(dt2.AsEnumerable(), DataRowComparer.Default).ToArray().CopyToDataTable();

           // dt1.AcceptChanges();
           // dt1.Merge(dt2);
            DataTable dtc = dt1.GetChanges();
            DataRow[] arr = tog.ToArray();
        }