GridView分页代码

GridView分页代码

 

前台

 

<asp:GridView ID="GridView1" runat="server" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" Width="1030px" AllowPaging="True" PageSize="5" onrowdatabound="GridView1_RowDataBound"> <HeaderStyle BackColor="#E6F2FF" HorizontalAlign="Center" Height="30px"/> <RowStyle HorizontalAlign="Center" /> <PagerStyle HorizontalAlign="Center" BackColor="#FFFFCC" BorderStyle="None" BorderWidth="0px" ForeColor="#330099" /> <PagerSettings Visible="False" /> </asp:GridView> <asp:LinkButton ID="lnkbtnFrist" runat="server" OnClick="lnkbtnFrist_Click">首页</asp:LinkButton> <asp:LinkButton ID="lnkbtnPre" runat="server" OnClick="lnkbtnPre_Click">上一页</asp:LinkButton> <asp:Label ID="lblCurrentPage" runat="server"></asp:Label> <asp:LinkButton ID="lnkbtnNext" runat="server" OnClick="lnkbtnNext_Click">下一页</asp:LinkButton> <asp:LinkButton ID="lnkbtnLast" runat="server" OnClick="lnkbtnLast_Click">尾页</asp:LinkButton> 跳转到第<asp:DropDownList ID="ddlCurrentPage" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> </asp:DropDownList>页

 

后台

#region 绑定GridIDView控件 public void GridAllBind(string Qualification) { GridView1Bind(Qualification); } public void GridView1Bind(string Qualification)//绑定GridView控件的自定义方法 { DataSet ds = new DataSet(); string sqlcmd = "select * from Price " + Qualification + " order by CreateDate desc,[Order] asc"; ds = OperateDB.GetResult(sqlcmd); if (ds.Tables[0].Rows.Count == 0) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridView1.DataSource = ds; GridView1.DataBind(); int columnCount = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = columnCount; GridView1.Rows[0].Cells[0].BorderColor = System.Drawing.Color.Black; GridView1.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Left; GridView1.Rows[0].Cells[0].Text = "暂时没有信息"; } else { GridView1.DataSource = ds; GridView1.DataKeyNames = new String[] { "ID" }; GridView1.DataBind(); } #region 绑定选择页下拉菜单 this.ddlCurrentPage.Items.Clear(); for (int i = 1; i <= this.GridView1.PageCount; i++) { this.ddlCurrentPage.Items.Add(i.ToString()); } this.ddlCurrentPage.SelectedIndex = this.GridView1.PageIndex; #endregion } #endregion

 

#region GridIDView1控件操作代码 protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { this.lblCurrentPage.Text = string.Format("当前第{0}页/总共{1}页", this.GridView1.PageIndex + 1, this.GridView1.PageCount); //遍历所有行设置边框样式 foreach (TableCell tc in e.Row.Cells) { tc.Attributes["style"] = "border-color:Black"; } } #endregion #region 分页操作部分的代码 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { this.GridView1.PageIndex = this.ddlCurrentPage.SelectedIndex; GridAllBind(HiddenField1.Value); } protected void lnkbtnFrist_Click(object sender, EventArgs e) { this.GridView1.PageIndex = 0; GridAllBind(HiddenField1.Value); } protected void lnkbtnPre_Click(object sender, EventArgs e) { if (this.GridView1.PageIndex > 0) { this.GridView1.PageIndex = this.GridView1.PageIndex - 1; GridAllBind(HiddenField1.Value); } } protected void lnkbtnNext_Click(object sender, EventArgs e) { if (this.GridView1.PageIndex < this.GridView1.PageCount) { this.GridView1.PageIndex = this.GridView1.PageIndex + 1; GridAllBind(HiddenField1.Value); } } protected void lnkbtnLast_Click(object sender, EventArgs e) { this.GridView1.PageIndex = this.GridView1.PageCount; GridAllBind(HiddenField1.Value); } #endregion