将多个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;

        }

posted @ 2011-09-15 11:21  Jack.G  阅读(429)  评论(0编辑  收藏  举报