62,074
社区成员
发帖
与我相关
我的任务
分享
<body style="text-align:center">
<form id="form1" runat="server">
<div>
<asp:DataList ID="DataList1" runat="server">
</asp:DataList></div>
<asp:LinkButton ID="lnkbtnFirst" runat="server" OnClick="lnkbtnFirst_Click">首页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnFront" runat="server" OnClick="lnkbtnFront_Click">上一页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnNext" runat="server" OnClick="lnkbtnNext_Click">下一页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnLast" runat="server" OnClick="lnkbtnLast_Click">尾页</asp:LinkButton>
当前页码为:<asp:Label ID="labPage" runat="server" Text="1"></asp:Label>
总页码为:
<asp:Label ID="labBackPage" runat="server" Text="Label"></asp:Label><br />
<br />
<br />
</form>
</body>
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 datalist2_fenye_function : System.Web.UI.Page
{
protected void Bind()
{
//获取当前页
int curpage = Convert.ToInt32(this.labPage.Text);
PagedDataSource ps = new PagedDataSource();
SqlConnection con= new SqlConnection("server=(local);database=studentDB;uid=sa;pwd=");
con.Open();
SqlDataAdapter sda=new SqlDataAdapter("select * from communicationbook",con);
DataSet ds=new DataSet();
sda.Fill(ds,"communicationbook");
//获取数据源
ps.DataSource = ds.Tables["communicationbook"].DefaultView;
ps.AllowPaging = true;
ps.PageSize = 3;
//设置当前页的索引
ps.CurrentPageIndex = curpage - 1;
this.lnkbtnFront.Enabled = true;
this.lnkbtnNext.Enabled = true;
this.lnkbtnLast.Enabled = true;
this.lnkbtnFirst.Enabled = true;
if (curpage == 1)//等于第一页
{
this.lnkbtnFront.Enabled = false;
this.lnkbtnFirst.Enabled = false;
}
if (curpage == ps.PageCount)//等于最后一页
{
this.lnkbtnNext.Enabled = false;
this.lnkbtnLast.Enabled = false;
}
//显示总页数
this.labBackPage.Text = Convert.ToString(ps.PageCount);
this.DataList1.DataSource = ps;
this.DataList1.DataKeyField="id";
DataList1.DataSource = ps;
//我感觉问题就出在前面这几行.大家帮忙看看 因为运行后只显示那些分页的导航的字,分页功能已经实现,可是DataList却没有实现数据的绑定.
DataList1.DataBind();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
protected void lnkbtnFirst_Click(object sender, EventArgs e)
{
labPage.Text = "1";
Bind();
}
protected void lnkbtnFront_Click(object sender, EventArgs e)
{
labPage.Text=Convert.ToString(Convert.ToInt32(labPage.Text)-1);
Bind();
}
protected void lnkbtnNext_Click(object sender, EventArgs e)
{
labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
Bind();
}
protected void lnkbtnLast_Click(object sender, EventArgs e)
{
labPage.Text = labBackPage.Text;
Bind();
}
}