AspNetPager+GridView implements paged instance code

2020-05-30 19:52:08
OfStack

The framework is.NET Framework 4.0
.1 consists of three parts: the design code of the front page, the program code of the front page, and the css style
Where the database connection operation USES DB class (connection statement), SQLHelper (Microsoft's database operation class)
Effect:

Foreground page design code


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TestWebSite.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">
    <title></title>
    <link href="Styles/Paging.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <asp:GridView ID="GridView1" runat="server" Height="261px" Width="737px" 
            CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle HorizontalAlign="Left" BackColor="#507CD1" Font-Bold="True" 
                ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>

    </div>
    <webdiyer:AspNetPager ID="AspNetPager1" runat="server" 
        onpagechanged="AspNetPager1_PageChanged" CssClass="anpager" 
        CurrentPageButtonClass="cpb" FirstPageText=" Home page " LastPageText=" back " 
        NextPageText=" After the page " PrevPageText=" Previous page ">
    </webdiyer:AspNetPager>
    </form>
</body>
</html>

Foreground page program code


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using TestWebSite.Utilities;
using System.Data;
using System.Data.SqlClient;
using Wuqi.Webdiyer;
namespace TestWebSite
{
    public partial class Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                // Call binding paging and GridView
                BindGridView();
            }
        }
        //// Bind paging and GridView methods 
        private void BindGridView()
        {
            // The query 
            string sequal = "select StandardName as  The name of the standard , MakeUpItem as  Compensation program , Unit as  unit ," 
                + " cast(UnitPrice as decimal(18,2)) as  The unit price , cast(StandRate as decimal(18,2)) as "
                + " The new rate , Type as  classification  from Standard";
            // Get data table 
            DataTable dt = 
                SqlHelper.ExecuteDataset(DB.con, CommandType.Text, sequal).Tables[0];
            // Initializes the split page data source instance 
            PagedDataSource pds = new PagedDataSource();
            // Set the total number of rows 
            AspNetPager1.RecordCount = dt.Rows.Count;
            // Set the paging data source 
            pds.DataSource = dt.DefaultView;
            // Set the current page 
            pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
            // Set the number of pages to display per page 
            pds.PageSize = AspNetPager1.PageSize;
            // Enable paging 
            pds.AllowPaging = true;
            // Set up the GridView Is the paging data source 
            GridView1.DataSource = pds;
            // The binding GridView
            GridView1.DataBind();
        }
        protected void AspNetPager1_PageChanged(object sender, EventArgs e)
        {
            // Call binding paging and GridView
            BindGridView();
        }
    }
}

CSS style


.anpager 
{ 
    font: 11px Arial, Helvetica, sans-serif;
    padding:10px 20px 10px 0; 
    margin: 0px;
}
.anpager a 
{
    padding: 1px 6px; 
    border: solid 1px #ddd; 
    background: #fff; 
    text-decoration: none;
    margin-right:2px
}
.anpager a:visited 
{
    padding: 1px 6px; 
    border: solid 1px #ddd; 
    background: #fff; 
    text-decoration: none;
}
.anpager .cpb 
{
    padding: 1px 6px;
    font-weight: bold; 
    font-size: 13px;
    border:none
}
.anpager a:hover 
{
    color: #fff; 
    background: #ffa501;
    border-color:#ffa501;
    text-decoration: none;
}

/* AspNetPager1 property setting: CssClass="anpager" CurrentPageButtonClass="cpb"*/