从Dataset dt中的DataTable1 dt1复制到DataTable2 dt2,方法如下:
foreach (DataRow row in dt.dt1.Rows)
{
DataRow DataTable2Row = Dataset.dt2.NewRow();
dt2Row ["REC_ID"] = CommomFun.GetRandomNum();//新增一列REC_ID并加入数据
foreach (DataColumn dc in dt.dt1.Columns)
{
dt2[dc.ColumnName] = row[dc];
}
dt.dt2.Rows.Add(DataTable2Row );
}