分页绑定Test

来源:互联网 发布:window phone10软件 编辑:程序博客网 时间:2024/05/22 05:33
<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());        }

0 0
原创粉丝点击