将一个datatable添加到一个新datatable

DataTable 插入新的DataTable中。

                DataTable dt = new DataTable();

                DataTable dt1 = new DataTable();
                DataTable dt2 = new DataTable();

                if (ds != null && ds.Tables.Count > 0)
                {
                    dt = ds.Tables[0];
                    dt1 = dt.Copy();
                    dt1.Clear();
                    dt2 = dt.Copy();
                    dt2.Clear();



                    if (dt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            if (dr["Syks"].ToString() == strKsdm)
                            {
                                dt1.ImportRow(dr);
                            }
                            else
                            {
                                dt2.ImportRow(dr);
                            }
                            //将表1数据导入到表2
                        }

                        foreach (DataRow dr in dt2.Rows)
                        {
                            dt1.ImportRow(dr);
                        }
                        dtStr = DataConvert.DataTable2Json2(dt1);
                    }
                }
                SQLHelper.ErrorLog(dtStr);