使用用户控件AspNetPager+Gridview实现分页功能

最新推荐文章于 2019-09-09 14:09:44 发布

weixin_34290000

最新推荐文章于 2019-09-09 14:09:44 发布

阅读量154

点赞数

文章标签： ui c#

原文链接：http://www.cnblogs.com/thbbsky/archive/2013/05/21/3091635.html

版权

1 前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TestPager.aspx.cs" Inherits="TestPager" %>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %> 
<!DOCTYPE html>
<html >
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div >
        <asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center">
            <RowStyle HorizontalAlign="Center" />
        </asp:GridView>
        <br/><br/><br/>
        <webdiyer:AspNetPager ID="AspNetPager1" runat="server" CustomInfoHTML="共%PageCount%页，
当前为第%CurrentPageIndex%页，每页%PageSize%条"
           FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页"
            ShowBoxThreshold="1" ShowCustomInfoSection="right" Width="100%" 
OnPageChanging="AspNetPager1_PageChanging" PageSize="1" ButtonImageAlign="Middle" 
CustomInfoTextAlign="Center" Direction="LeftToRight" HorizontalAlign="Center" NumericButtonCount="5" 
CenterCurrentPageButton="True">
            </webdiyer:AspNetPager>  
    </div>
    </form>
</body>
</html>

2后台代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public partial class TestPager : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GridBindData();
          
        }
    }

    private void GridBindData()
    {
        string strConn = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(strConn))
        {
            con.Open();
            string sql = "select t.* from Student t";
            using (SqlCommand cmd = new SqlCommand(sql, con))
            {
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    DataSet ds = new DataSet();
                    da.Fill(ds, "Student");
                    PagedDataSource pds = new PagedDataSource();
                    pds.DataSource = ds.Tables[0].DefaultView;
                    pds.AllowPaging = true;
                    AspNetPager1.RecordCount = pds.Count;
                    pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
                    pds.PageSize = AspNetPager1.PageSize;
                    this.GridView1.DataSource = pds;
                    this.GridView1.DataBind();
                
                }
            
            }
        
        
        }
    }
    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        GridBindData();
    }  
}

3 测试截图：

转载于:https://www.cnblogs.com/thbbsky/archive/2013/05/21/3091635.html

weixin_34290000

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
使用用户控件AspNetPager+Gridview实现分页功能

1 前台代码：<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TestPager.aspx.cs" Inherits="TestPager" %><%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiye...
复制链接

扫一扫