木棉

导航

DataTable结果集分页

public DataTable Paging(DataTable dt, int pageIndex, int pageSize)
    {
        DataTable result = new DataTable();
        if (dt != null && dt.Rows.Count > 0)
        {
           result = dt.Clone();
           DataRow[] rows = dt.AsEnumerable().Skip((pageIndex - 1) * pageSize).Take(pageSize).ToArray();
           foreach (DataRow item in rows)
           {
               result.ImportRow(item);
           }
        }
        return result;
    }

posted on 2012-03-08 14:59  木棉  阅读(492)  评论(0)    收藏  举报