asp.net列表数据显示+分页

[c-sharp] view plaincopy
  1. /// <summary>                                                                           
  2. /// 分页函数                                                                              
  3. /// </summary>                                                                              
  4. /// <param name="dtRecord">数据源</param>                                                                            
  5. private void SplitPage(DataTable dtRecord)                                                                            
  6. {                                                                             
  7.     string htmlPage = "";                                                                         
  8.     int pageSize = 15;                          //每页显示记录数                                             
  9.     int listStep = 10;                          //最多显示分页页数                                            
  10.     int pages = 1;                          //当前页,默认显示第一页                                             
  11.     int pageCount = 0;                          //定义总页数                                           
  12.     int recordCount = 0;                            //定义总记录数                                              
  13.     int listBegin = 0;                          //从第几页开始显示分页信息                                            
  14.     int listEnd = 0;                            //分页信息显示到第几页                                              
  15.                                                                               
  16.     if (dtRecord == null || dtRecord.Rows.Count == 0)                                                                         
  17.     {                                                                         
  18.         return;                                                                   
  19.     }                                                                         
  20.     recordCount = dtRecord.Rows.Count;                                                                        
  21.                                                                               
  22.     //确定数据记录要显示的页面数                                                                       
  23.     if(recordCount > 0)                                                                        
  24.     {                                                                         
  25.         pageCount = recordCount / pageSize;                                                                   
  26.     }                                                                         
  27.     if(recordCount % pageSize > 0)                                                                         
  28.     {                                                                         
  29.         pageCount++;                                                                      
  30.     }                                                                         
  31.                                                                               
  32.     //取得当前页数值,并判断                                                                         
  33.     if(Request["pages"] != null)                                                                          
  34.     {                                                                         
  35.         pages = Convert.ToInt32(Request["pages"]);                                                                    
  36.     }                                                                         
  37.     if(pages < 1)                                                                          
  38.     {                                                                         
  39.         pages = 1;                                                                    
  40.     }                                                                         
  41.     if(pages > pageCount)                                                                          
  42.     {                                                                         
  43.         pages = pageCount;                                                                    
  44.     }                                                                         
  45.                                                                               
  46.     listBegin = pages - listStep / 2;     //从第几页开始显示分页信息                                                                          
  47.     if (listBegin < 1)                                                                         
  48.     {                                                                         
  49.         listBegin = 1;                                                                    
  50.     }                                                                         
  51.                                                                               
  52.     listEnd = listBegin + listStep - 1;   //分页信息显示到第几页                                                                        
  53.     if (listEnd > pageCount)                                                                           
  54.     {                                                                         
  55.         listEnd = pageCount;                                                                      
  56.         listBegin = listEnd - listStep + 1;                                                                   
  57.                                                                               
  58.         if (listBegin < 1)                                                                     
  59.         {                                                                     
  60.             listBegin = 1;                                                                
  61.         }                                                                     
  62.     }                                                                         
  63.                                                                               
  64.     //确认当前页面的开始记录和终止记录                                                                        
  65.     int recordBegin  = pageSize * (pages - 1);                                                                        
  66.     int recordEnd = recordBegin + pageSize - 1;                                                                       
  67.     if(recordEnd > recordCount - 1)                                                                        
  68.     {                                                                         
  69.         recordEnd = recordCount - 1;                                                                      
  70.     }                                                                         
  71.                                                                               
  72.     //显示数据记录                                                                          
  73.     htmlPage = DisplayDataRecord(dtRecord, recordBegin, recordEnd);                                                                       
  74.     Response.Write(htmlPage);                                                                         
  75.     htmlPage = "";                                                                        
  76.                                                                               
  77.     //显示分页列表                                                                          
  78.     htmlPage +=  GetPageList(pages, pageCount, listBegin, listEnd);                                                                       
  79.     Response.Write(htmlPage);                                                                         
  80.     htmlPage = "";                                                                        
  81. }   
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,下面是ASP.NET使用数据绑定控件分页显示数据的步骤: 1. 在ASP.NET页面添加一个数据绑定控件,如GridView或Repeater,可以通过“数据”工具箱的控件来添加。 2. 在数据绑定控件设置数据源,可以使用SqlDataSource或ObjectDataSource等控件来设置数据源。如果是使用SqlDataSource控件,可以在ASP.NET页面添加以下代码: ```asp <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM 表名"></asp:SqlDataSource> ``` 3. 设置数据绑定控件的属性,如DataSource和DataBind,将数据源与数据绑定控件绑定。例如,使用GridView控件绑定数据源的代码如下: ```asp <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"> </asp:GridView> ``` 4. 添加一个分页控件,如Pager或DataPager,用于实现分页功能。可以通过“数据”工具箱的控件来添加。 5. 设置分页控件的属性,如PageSize、PagedControlID等,用于指定每页显示数据条数和分页控件所对应的数据绑定控件的ID。 例如,使用DataPager控件实现分页的代码如下: ```asp <asp:DataPager ID="DataPager1" runat="server" PageSize="10" PagedControlID="GridView1"> </asp:DataPager> ``` 6. 运行ASP.NET页面即可看到数据绑定控件已经实现了分页显示数据,可以通过分页控件来翻页,展示不同的数据。 希望这些步骤能够帮助到你,如果还有其他问题,请继续提问。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值