前台代码:
<asp:GridView ID="gvUserInfo" runat="server" AllowPaging="True"
AutoGenerateColumns="False" onpageindexchanging="gvUserInfo_PageIndexChanging"
onrowdeleting="gvUserInfo_RowDeleting" DataKeyNames="UserId" PageSize="5"
Width="650px">
<HeaderStyle BackColor="#E7E7E7" />
<PagerStyle BackColor="#E7E7E7" />
<Columns>
<asp:BoundField DataField="UserAccount" HeaderText="用户帐号" />
<asp:BoundField DataField="Password" HeaderText="用户密码" />
<asp:BoundField DataField="UserName" HeaderText="用户姓名" />
<asp:BoundField DataField="UserGender" HeaderText="性别" />
<asp:BoundField DataField="UserBirthday" HeaderText="出生日期" />
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"
CommandName="Delete" Text="删除" OnClientClick="return confirm('您确认删除这条记录吗?');" Width="40px">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerTemplate>
<asp:Label ID="lb_Pagecount" runat="server" ForeColor="Blue"></asp:Label>
<asp:Label ID="lb_Currentpage" runat="server" ForeColor="Blue"></asp:Label>
<asp:LinkButton ID="lbtn_First" runat="server" CommandArgument="0" OnClick="PagerButtonClick" Text="首页" Width="40px"></asp:LinkButton>
<asp:LinkButton ID="lbtn_Prev" runat="server" CommandArgument="prev" OnClick="PagerButtonClick" Text="上一页" Width="50px"></asp:LinkButton>
<asp:LinkButton ID="lbtn_Next" runat="server" CommandArgument="next" OnClick="PagerButtonClick" Text="下一页" Width="50px"></asp:LinkButton>
<asp:LinkButton ID="lbtn_Last" runat="server" CommandArgument="last" OnClick="PagerButtonClick" Text="尾页" Width="40px"></asp:LinkButton>
</PagerTemplate>
</asp:GridView>
后台.cs:
public partial class Administrator_Admin : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
gv_DataBind();
string admin = Session["userAccount"].ToString();
lbAdminName.Text = admin;
}
//为GridView绑定数据
public void gv_DataBind()
{
DataAccess da = new DataAccess();
DataSet ds=da.bindGridView();
this.gvUserInfo.DataSource = ds.Tables[0].DefaultView;
this.gvUserInfo.DataBind();
//获取gridview控件中的底部页导航行
GridViewRow gvr = this.gvUserInfo.BottomPagerRow;
((Label)gvr.FindControl("lb_currentPage")).Text = "第" + (gvUserInfo.PageIndex+1).ToString() + "页";
((Label)gvr.FindControl("lb_Pagecount")).Text = "总共" + gvUserInfo.PageCount.ToString() + "页";
}
//分页功能实现
protected void gvUserInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.gvUserInfo.PageIndex = e.NewPageIndex;
gv_DataBind();
}
//删除功能
protected void gvUserInfo_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string userId = this.gvUserInfo.DataKeys[e.RowIndex].Value.ToString();
DataAccess da = new DataAccess();
da.deleteRecord(userId);
gv_DataBind();
}
//分页按钮事件
public void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch (arg)
{
case "next":
if (gvUserInfo.PageIndex < (gvUserInfo.PageCount - 1))
{
gvUserInfo.PageIndex += 1;
}
break;
case "prev":
if (gvUserInfo.PageIndex > 0)
{
gvUserInfo.PageIndex -= 1;
}
break;
case "last":
gvUserInfo.PageIndex = gvUserInfo.PageCount - 1;
break;
default:
gvUserInfo.PageIndex = 0;
break;
}
gv_DataBind();
}