数据表分页

    public static DataTable FilterData(DataTable dt, int pageSize, int pageIndex)
    {
        DataTable dt2 = new DataTable();
        for (int i = 0; i < dt.Columns.Count; i++)
        {
            dt2.Columns.Add(dt.Columns[i].ColumnName, dt.Columns[i].DataType);
        }

        int end = pageSize * pageIndex;
        if (dt.Rows.Count < end)
            end = dt.Rows.Count;

        for (int i = pageSize * (pageIndex - 1); i < end; i++)
        {
            DataRow dr = dt2.NewRow();
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                string col = dt.Columns[j].ColumnName;
                dr[col] = dt.Rows[i][col];
            }
            dt2.Rows.Add(dr);
        }

        return dt2;
    }