AspNetPager分页控件的有关问题
日期：2014-05-17 浏览次数：20414 次
AspNetPager分页控件的问题
本菜使用AspNetPager分页控件进行分页，设置每页显示1条，表中共有4条记录，但只能看到第一页的，没法看其他页的，请帮忙解决
前台代码：
后台代码：
------解决方案--------------------
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["AppServices"]);
conn.Open();
SqlCommand cmd = new SqlCommand("select * from good order by id desc", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
rtInfo.DataSource = pds;
rtInfo.DataBind();
这样写
本菜使用AspNetPager分页控件进行分页，设置每页显示1条，表中共有4条记录，但只能看到第一页的，没法看其他页的，请帮忙解决
前台代码：
- C# code
<body>
<form id="form1" runat="server">
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<div><%#Eval("name")%></div>
</ItemTemplate>
</asp:Repeater>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="true"
PageSize="1" CssClass="paginator" CurrentPageButtonClass="cpb"
LastPageText="尾页" FirstPageText="首页" PrevPageText="上一页" NextPageText="下一页"
UrlPaging="True" NumericButtonTextFormatString="{0}"
ShowCustomInfoSection="Right"
onpagechanged="AspNetPager1_PageChanged" CustomInfoTextAlign="Left"
LayoutType="Div" >
</webdiyer:AspNetPager>
</form>
</body>
后台代码：
- C# code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using Wuqi.Webdiyer;
namespace c_displays
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
Bind();
}
public void Bind()
{
this.AspNetPager1.RecordCount = linksql.count("select * from good");
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["AppServices"]);
conn.Open();
SqlCommand cmd = new SqlCommand("select * from good order by id desc", conn);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds, AspNetPager1.PageSize * (this.AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "temp");
DataTable dt = ds.Tables["temp"];
Repeater1.DataSource = dt;
Repeater1.DataBind();
conn.Close();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
Bind();
}
}
}
------解决方案--------------------
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["AppServices"]);
conn.Open();
SqlCommand cmd = new SqlCommand("select * from good order by id desc", conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
rtInfo.DataSource = pds;
rtInfo.DataBind();
这样写
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
