将多个Datatable合并到另外一个DataTable中,并获取其中有用的值
private DataTable UnitTable()
{
DataTable newtable = GetDtA().Clone();
object[] obj = new object[newtable.Columns.Count];
for (int i = 0; i < GetDtA().Rows.Count; i++)
{
GetDtA().Rows[i].ItemArray.CopyTo(obj, 0);
newtable.Rows.Add(obj);
}
for (int i = 0; i < GetDtB().Rows.Count; i++)
{
GetDtB().Rows[i].ItemArray.CopyTo(obj, 0);
newtable.Rows.Add(obj);
}
DataView dv = newtable.DefaultView;
dv.RowFilter = "Month='3' and Year='2011'";
return newtable;
}