asp.net分页显示数据库中的数据

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

namespace NewsManagementSystem
{
    public class Paging
    {
        private DataTable initDt;       
        public int pageindex;

        public int pagecount;
        //public int RecordCount;
        //public int PageCount;

        public Paging(DataTable _initDt, int _pagecount, int _pageindex)
        {
            this.initDt = _initDt;
            this.pagecount = _pagecount;
            this.pageindex = _pageindex;
        }

        public int GetRecordCount()
        {
            return this.initDt.Rows.Count;
        }

        public int GetPageCount()
        {
            // 除法小数的问题
            int x = this.initDt.Rows.Count % this.pagecount;
            if (x == 0)
            {
                return this.initDt.Rows.Count / this.pagecount;
            }
            else
            {
                return this.initDt.Rows.Count / this.pagecount + 1;
            }
        }

        public DataTable GetPageByIndex()
        {
            //65 10 3
            //(3-1)*10+1    3*10
            //(pageindex-1)*pagecount+1    pageindex*pagecount

            //initDt null  0;pageindex <=0 >; pagecount <=

            DataTable dt = this.initDt.Clone();
            for (int i = (pageindex-1)*pagecount; i < pageindex*pagecount && i<this.GetRecordCount(); i++)
            {
                dt.Rows.Add(initDt.Rows[i].ItemArray);
            }
            return dt;
        }
    }
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值