gridview实现分页
前臺代碼:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
??????????? AutoGenerateColumns="False" DataKeyNames="ScoreID"
??????????? DataSourceID="SqlDataSource1" onpageindexchanging="GridView1_PageIndexChanging"?
??????????? Width="100%" EmptyDataText="沒有數據記錄!"
??????????? BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
??????????? CellPadding="3" GridLines="Horizontal">
??????????? <AlternatingRowStyle BackColor="#F7F7F7" />
??????????? <Columns>
??????????????? <asp:BoundField DataField="ScoreID" HeaderText="成績編號" ReadOnly="True"
??????????????????? SortExpression="ScoreID" />
??????????????? <asp:BoundField DataField="CourseID" HeaderText="課程編號"
??????????????????? SortExpression="CourseID" />
??????????????? <asp:BoundField DataField="StuScore" HeaderText="學生成績"
??????????????????? SortExpression="StuScore" />
??????????????? <asp:BoundField DataField="StuID" HeaderText="學生編號" SortExpression="StuID" />
??????????? </Columns>
??????????? <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
??????????? <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
??????????? <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
??????????? <PagerTemplate>
??????????????? 當前第:
?????????????? <%-- //((GridView)Container.NamingContainer)就是為了得到當前的控件--%>
??????????????? <asp:Label ID="LabelCurrentPage" runat="server" Text="<%# ((GridView)Container.NamingContainer).PageIndex + 1 %>"></asp:Label>
??????????????? 頁/共:
?????????????? <%-- //得到分頁頁面的總數--%>
??????????????? <asp:Label ID="LabelPageCount" runat="server" Text="<%# ((GridView)Container.NamingContainer).PageCount %>"></asp:Label>
??????????????? 頁
???????????????? <%--//如果該分頁是首分頁,那么該連接就不會顯示了.同時對應了自帶識別的命令參數CommandArgument--%>
??????????????? <asp:LinkButton ID="LinkButtonFirstPage" runat="server" CommandArgument="First" CommandName="Page"
??????????????????? Visible='<%#((GridView)Container.NamingContainer).PageIndex != 0 %>'>首頁</asp:LinkButton>
??????????????? <asp:LinkButton ID="LinkButtonPreviousPage" runat="server" CommandArgument="Prev"
??????????????????? CommandName="Page" Visible='<%# ((GridView)Container.NamingContainer).PageIndex != 0 %>'>上一頁</asp:LinkButton>
?????????????? <%--//如果該分頁是尾頁,那么該連接就不會顯示了--%>
??????????????? <asp:LinkButton ID="LinkButtonNextPage" runat="server" CommandArgument="Next" CommandName="Page"
??????????????????? Visible='<%# ((GridView)Container.NamingContainer).PageIndex != ((GridView)Container.NamingContainer).PageCount - 1 %>'>下一頁</asp:LinkButton>
??????????????? <asp:LinkButton ID="LinkButtonLastPage" runat="server" CommandArgument="Last" CommandName="Page"
??????????????????? Visible='<%# ((GridView)Container.NamingContainer).PageIndex != ((GridView)Container.NamingContainer).PageCount - 1 %>'>尾頁</asp:LinkButton>
??????????????? 轉到第
??????????????? <asp:TextBox ID="txtNewPageIndex" runat="server" Width="20px" Text='<%# ((GridView)Container.Parent.Parent).PageIndex + 1 %>' />頁
??????????????? <%--//這里將CommandArgument即使點擊該按鈕e.newIndex 值為3 --%>
??????????????? <asp:LinkButton ID="btnGo" runat="server" CausesValidation="False" CommandArgument="-2"
??????????????????? CommandName="Page" Text="GO" />
??????????? </PagerTemplate>
??????????? <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
??????????? <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
??????????? <SortedAscendingCellStyle BackColor="#F4F4FD" />
??????????? <SortedAscendingHeaderStyle BackColor="#5A4C9D" />
??????????? <SortedDescendingCellStyle BackColor="#D8D8F0" />
??????????? <SortedDescendingHeaderStyle BackColor="#3E3277" />
??????? </asp:GridView>
?
后臺代碼:
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) ???????
{ ???????????
GridView theGrid = sender as GridView; ???????????
int newPageIndex = 0; ???????????
if (e.NewPageIndex == -3) ???????????
{ ???????????????
//點擊了Go按鈕 ???????????????
TextBox txtNewPageIndex = null; ???????????????
//GridView較DataGrid提供了更多的API,獲取分頁塊可以使用BottomPagerRow 或者TopPagerRow,當然還增加了HeaderRow和FooterRow ???????????????
GridViewRow pagerRow = theGrid.BottomPagerRow; ???????????????
if (pagerRow != null) ???????????????
{ ???????????????????
//得到text控件 ???????????????????
txtNewPageIndex = pagerRow.FindControl("txtNewPageIndex") as TextBox; ???????????????
} ???????????????
if (txtNewPageIndex != null) ???????????????
{ ???????????????????
//得到索引 ???????????????????
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; ???????????????
} ???????????
} ???????????
else ???????????
{ ???????????????
//點擊了其他的按鈕 ???????????????
newPageIndex = e.NewPageIndex; ???????????
} ???????????
//防止新索引溢出 ???????????
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex; ???????????
newPageIndex = newPageIndex >= theGrid.PageCount ? theGrid.PageCount - 1 : newPageIndex; ???????????
//得到新的值 ???????????
theGrid.PageIndex = newPageIndex; ???????????
//重新綁定 ???????????
GridView1.DataBind();
??????? }
轉載于:https://www.cnblogs.com/JCH344/p/6029201.html
總結
以上是生活随笔為你收集整理的gridview实现分页的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: MySQL存储过程相互调用
- 下一篇: excel下划线转驼峰公式