1.在datalist标签</datalist>下方添加
<div style="font-size:small; width:100%; text-align:center">
第<asp:Label ID="lblCurrent" runat="server"></asp:Label>页
<asp:Label ID="lblCount" runat="server" Text="/"></asp:Label>
<asp:LinkButton ID="lbtnFirst" runat="server" CommandName="First"
oncommand="lbtnFirst_Command">首页</asp:LinkButton>
<asp:LinkButton ID="lbtnPrev" runat="server" CommandName="Prev"
oncommand="lbtnFirst_Command" >上一页</asp:LinkButton>
<asp:LinkButton ID="lbtnNext" runat="server" CommandName="Next"
oncommand="lbtnFirst_Command">下一页</asp:LinkButton>
<asp:LinkButton ID="lbtnLast" runat="server" CommandName="Last"
oncommand="lbtnFirst_Command">末页</asp:LinkButton>
</div>
2.在后台代码中添加:
static string selectSql = "select * from a1User";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
getData(1,selectSql);
}
}
static int i;
private void getData(int pageIndex,string selectSql)
{
PagedDataSource pd = new PagedDataSource();
pd.AllowPaging = true;
pd.PageSize = 5;
pd.CurrentPageIndex = pageIndex - 1;
pd.DataSource = DbHelper.GetDataSet(selectSql).DefaultView;
DataList1.DataSource = pd;
DataList1.DataBind();
lblCurrent.Text = Convert.ToString(pd.CurrentPageIndex + 1);
lblCount.Text = "/共";
lblCount.Text += pd.PageCount.ToString()+"页";
i = pd.PageCount;
if (pd.IsFirstPage)
{
lbtnFirst.Enabled= false;
lbtnPrev.Enabled= false;
}
else
{
lbtnFirst.Enabled= true;
lbtnPrev.Enabled= true;
}
if (pd.IsLastPage)
{
lbtnLast.Enabled= false;
lbtnNext.Enabled= false;
}
else
{
lbtnLast.Enabled= true;
lbtnNext.Enabled= true;
}
}
protected void lbtnFirst_Command(object sender, CommandEventArgs e)
{
switch (e.CommandName)
{
case "First":
getData(1, selectSql);
break;
case "Next":
getData(Convert.ToInt32(lblCurrent.Text) + 1, selectSql);
break;
case "Prev":
getData(Convert.ToInt32(lblCurrent.Text) - 1, selectSql);
break;
case "Last":
getData(i, selectSql);
break;
default:
getData(1, selectSql);
break;
}
}