DataTable属性及操作

1、DataTable.ImportRow(dt.rows[i])导入行,将已有DataTable行导入到新的DataTable中去。

实例：分页时,先将数据存储在DataTable中,再根据页大小PageSize、页码PageIndex对DataTable进行划分取值。

#region

public static DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize)
        {
            try
            {

                if (PageIndex == 0) return dt;
                if (dt == null) return dt;
                DataTable newdt = dt.Clone();

                int rowbegin = (PageIndex - 1) * PageSize;
                int rowend = PageIndex * PageSize;

                if (rowbegin >= dt.Rows.Count) return newdt;

                if (rowend > dt.Rows.Count)
                    rowend = dt.Rows.Count;

                for (int i = rowbegin; i <= rowend - 1; i++)
                {
                    newdt.ImportRow(dt.Rows[i]);
                }

                return newdt;

            }
            catch (Exception ex)
            {
                throw ex;
            }

        }

#endregion