GridView 如何实现 AspNetPager 分页??

cbting 2010-04-24 05:38:34

GridView 如何实现 AspNetPager 分页?? 用数据库取到的数据是DataTable 如何在 GridView 与 AspNetPager 绑定分页??

...全文

195 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

sunzhong2003 2010-04-25

打赏
举报

找分页空间的管网，下个DEMO，大侠一句做了不少了，可以很好的参考

zhouwei7682719 2010-04-25

打赏
举报

随便搜一下一大片

kk297173176 2010-04-25

打赏
举报

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
int curpage = 1;
private void bind()
{
string sqlconn = System.Configuration.ConfigurationManager.ConnectionStrings["sql"].ToString();
SqlConnection conn = new SqlConnection(sqlconn);
SqlDataAdapter sda = new SqlDataAdapter("select * from tb_user", conn);
DataSet ds = new DataSet();

conn.Open();
sda.Fill(ds);
conn.Close();

this.AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
this.GridView1.AllowPaging = true;
this.GridView1.PageIndex = curpage;
this.GridView1.PageSize = 15;
this.AspNetPager1.PageSize = 15;

this.GridView1.DataSource = ds;
this.GridView1.DataBind();
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
curpage = e.NewPageIndex-1;
bind();
}

oyjd614 2010-04-25

打赏
举报

代码如下，希望对你有所帮助



    private void BindData(int pageIndex)

        {

            // Get datasource

            // To do

            // Settding aspnetpager record count

            anpNews.RecordCount = currentPage.TotalCount;

            // Bind datasource

        }

    protected void anpNews_PageChanged(object sender, EventArgs e)

        {

            BindNewsList(anpNews.CurrentPageIndex - 1);

        }



   <ccl:AspNetPager ID="anpNews" runat="server" HorizontalAlign="Center" PageSize="13"

                        CurrentPageButtonClass="cpb" CssClass="anpager" AlwaysShow="True" OnPageChanged="anpNews_PageChanged"

                        ShowFirstLast="true" ShowPrevNext="true" NextPageText="下一页" PrevPageText="上一页"

                        FirstPageText="首页" LastPageText="尾页">

                    </ccl:AspNetPager>

vip__888 2010-04-25

打赏
举报

google grv72变

gdlpc 2010-04-25

打赏
举报

测试通过的
//aspx页面：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AspNetPager.aspx.cs" Inherits="AspNetPager" %>

<%@ 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>AspNetPager分页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="首页" LastPageText="末页" NextPageText="下一页" PrevPageText="上一页" ShowCustomInfoSection="Left" ShowNavigationToolTip="True" SubmitButtonText="go转到" OnPageChanged="AspNetPager1_PageChanged" Font-Size="10pt" Width="457px">
</webdiyer:AspNetPager>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>

</div>
</form>
</body>
</html>

//.cs页面：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class AspNetPager : System.Web.UI.Page
{
DataSet ds;
SqlDataAdapter dr;
SqlCommand com;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["SperConnectionString1"].ToString();
string strconn = "Data Source=(local);Database=INFO;Uid=sa;Pwd=5354";
SqlConnection con = new SqlConnection(strconn);
con.Open();
com = new SqlCommand();
com.Connection = con;
com.CommandText = "select count(*) from zhong";
AspNetPager1.AlwaysShow = true;
//AspNetPager1.PageSize = 5;
AspNetPager1.RecordCount = (int)com.ExecuteScalar();
con.Close();
RepeaterDataBind();
}
}

private void RepeaterDataBind()
{
//string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["SperConnectionString1"].ToString();
string strconn = "Data Source=(local);Database=INFO;Uid=sa;Pwd=5354";
dr = new SqlDataAdapter("select * from zhong", strconn);
ds = new DataSet();
dr.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "zhong");
this.GridView1.DataSource = ds.Tables["zhong"];
this.GridView1.DataBind();

AspNetPager1.CustomInfoHTML = " 总页数：<b>" + AspNetPager1.PageCount.ToString() + "</b>";
AspNetPager1.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
}

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
RepeaterDataBind();
}
//protected string FormatString_Size_13(string str)
//{//这里的代码可以不使用
// if (str.Length > 33)
// {
// str = str.Substring(0, 32) + "";
// }
// return str;
//}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
RepeaterDataBind();
}
}