• asp.net分页控件


    一、说明

      AspNetPager.dll这个分页控件主要用于asp.net webform网站,现将整理代码如下

    二、代码

      1、首先在测试页面Default.aspx页面添加引用

    <%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
    

      2、写一个Repeater列表控件用于显示数据

    <asp:Repeater ID="rptNews" runat="server">
      <ItemTemplate>
        <li>
          <span><%# Eval("time") %></span>
          <a href="NewsShow.aspx?id=<%# Eval("id") %>"><%# Access.GetStringNum( Eval("name").ToString(),15) %></a>
        </li>
      </ItemTemplate>
    </asp:Repeater>

      3、添加

    <webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True" CustomInfoStyle="FONT-SIZE: 12px"
                    FirstPageText="首页" HorizontalAlign="Center" inputboxstyle="19px" LastPageText="尾页"
                    meta:resourcekey="AspNetPager1" NextPageText="下一页" PageSize="10" PrevPageText="上一页"
                    Style="font-size: 14px" Width="95%" CssClass="anpager" CurrentPageButtonClass="cpb"
                    OnPageChanging="AspNetPager1_PageChanging" ShowBoxThreshold="10">
    </webdiyer:AspNetPager>
    

      PageSize属性是用于设置每页显示的数量

      4、后台代码绑定

    //测试数据源
    private void ShowNews() {   String strSql = String.Format("select * from News order by time asc");   DataTable dtbl = Access.ExecuteDataTable(strSql, null);   this.rptNews.DataSource = Access.GetPageDataSource(AspNetPager1, AspNetPager1.CurrentPageIndex - 1, dtbl);   this.rptNews.DataBind(); }

      Access是测试数据库访问类,在最后的Demo中提供给大家

      5、分页控件点击页码事件

    //分页
    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
      this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
      ShowNews();
    }
    

      最后奉上整页代码:

      Default.aspx

    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default" %>
    
    <%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>asp.net分页控件</title>
        <link href="css/css.css" rel="stylesheet" type="text/css" />
        <style type="text/css">
        .aboutcontentnr{100%; height:auto; }
        </style>
    </head>
    <body>
        <form id="form1" runat="server">
        <div>
            <ul class="news">
                <asp:Repeater ID="rptNews" runat="server">
                    <ItemTemplate>
                        <li><span>
                            <%# Eval("time") %></span><a href="NewsShow.aspx?id=<%# Eval("id") %>"><%# Access.GetStringNum( Eval("name").ToString(),15) %></a></li>
                    </ItemTemplate>
                </asp:Repeater>
            </ul>
            <div class="paginator">
                <webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True" CustomInfoStyle="FONT-SIZE: 12px"
                    FirstPageText="首页" HorizontalAlign="Center" inputboxstyle="19px" LastPageText="尾页"
                    meta:resourcekey="AspNetPager1" NextPageText="下一页" PageSize="10" PrevPageText="上一页"
                    Style="font-size: 14px" Width="95%" CssClass="anpager" CurrentPageButtonClass="cpb"
                    OnPageChanging="AspNetPager1_PageChanging" ShowBoxThreshold="10">
                </webdiyer:AspNetPager>
            </div>
        </div>
        </form>
    </body>
    </html>

      Default.aspx.cs

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Data;
    
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ShowNews();
            }
        }
    
        //测试数据源
        private void ShowNews()
        {
            String strSql = String.Format("select * from News order by time asc");
            DataTable dtbl = Access.ExecuteDataTable(strSql, null);
            this.rptNews.DataSource = Access.GetPageDataSource(AspNetPager1, AspNetPager1.CurrentPageIndex - 1, dtbl);
            this.rptNews.DataBind();
        }
    
        //分页点击页码事件
        protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
        {
            this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
            ShowNews();
        }
    }
    

    三、Demo

      AspNetPager(dll)

      AspNetPage(Demo)

    作者:小路 QQ:2490024434 
    出处:http://www.cnblogs.com/lengzhan/ 
    本文版权归【冷战】和博客园所有,欢迎转载收藏,未经作者同意须保留此段声明,否则保留追究法律责任的权利。

  • 相关阅读:
    leetcode 3sum
    leetcode majority elements
    php调取linux的压缩命令进行压缩
    mysql 分区、分表、分库分表。
    如何在数据库中使用索引
    PDO 的基本操作
    JavaScript中常见的字符串操作函数及用法汇总
    php-fpm
    phpmyadmin导入导出数据库文件最大限制的解决方法
    php 获取今日、昨日、上周、本月的起始时间戳和结束时间戳。
  • 原文地址:https://www.cnblogs.com/lengzhan/p/6054583.html
Copyright © 2020-2023  润新知