分页绑定Test

临冰听雪

于 2014-10-15 11:11:27 发布

阅读量416

点赞数

分类专栏： it 文章标签：分页

本文链接：https://blog.csdn.net/u013176520/article/details/40108277

版权

it 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" Width="100%"  AlwaysShow="false" 
        CenterCurrentPageButton="True" FirstPageText="首页" LastPageText="末一页" NextPageText="下一页"
         PrevPageText="上一页" onpagechanged="AspNetPager1_PageChanged">
            </webdiyer:AspNetPager>

private void bindData()
        {
            //实例化数据层
            SQLProtectOperation<MYEWM.Entity.TestMVC> test = new SQLProtectOperation<MYEWM.Entity.TestMVC>();
            //实例化返回数据
            System.Text.StringBuilder sbu = new System.Text.StringBuilder();
            //实例化实体
            MYEWM.Entity.TestMVC testMVC = new MYEWM.Entity.TestMVC();
            //当前页
            int pageindex = 1;
            //页面显示条数
            int pagesize = 2;
            //当前页数
            int pagercount = 0;

            pageindex = AspNetPager1.CurrentPageIndex;
            //给空间页面大小
            AspNetPager1.PageSize = pagesize;
            //给存储过程数据
            //System.Data.DataTable dt = test.CommPageToSql("select name,ROW_NUMBER() over(order by id desc) as myrank from TestMVC", pageindex, pagesize, ref pagercount, out sbu).Tables[0];
            System.Data.DataTable dt = test.CommPageToEntity(testMVC, "", "id desc ", pageindex, pagesize, ref pagercount, out sbu).Tables[0];
            //绑定
            this.rpt_findAll.DataSource = dt;
            //给控件赋值页数
            this.AspNetPager1.RecordCount = pagercount;
            //
            this.rpt_findAll.DataBind();
            //输出返回数据
            Response.Write(sbu.ToString());
        }