微軟的DataPager分頁(yè)功能很強(qiáng)大，不要設(shè)置數(shù)據(jù)庫(kù)存儲(chǔ)過(guò)程，只要添加個(gè)DataPager控件，關(guān)聯(lián)下要分頁(yè)的控件，簡(jiǎn)單設(shè)置就可以有不錯(cuò)的分頁(yè)效果。當(dāng)然要有更理想的效果還是要前臺(tái)和后臺(tái)處理下。
winform下的DataPager 顯示模式:
webForm下的樣式由TemplatePagerField，NextPreviousPagerField和NumericPagerField控制
通過(guò)設(shè)置上面幾個(gè)控件的配合也可以達(dá)到winForm下的效果，這3個(gè)控件中最重要的是TemplatePagerField控件。
下面簡(jiǎn)單看看TemplatePagerField控件可以怎么設(shè)置：
復(fù)制代碼 代碼如下:
%@ Page language="VB" %>
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
script runat="server">
Protected Sub TemplatePagerField_OnPagerCommand(ByVal sender As Object, _
ByVal e As DataPagerCommandEventArgs)
' Check which button raised the event
Select Case e.CommandName
Case "Next"
Dim newIndex As Integer = e.Item.Pager.StartRowIndex + e.Item.Pager.PageSize
If newIndex = e.TotalRowCount Then
e.NewStartRowIndex = newIndex
e.NewMaximumRows = e.Item.Pager.MaximumRows
End If
Case "Previous"
e.NewStartRowIndex = e.Item.Pager.StartRowIndex - e.Item.Pager.PageSize
e.NewMaximumRows = e.Item.Pager.MaximumRows
Case "First"
e.NewStartRowIndex = 0
e.NewMaximumRows = e.Item.Pager.MaximumRows
End Select
End Sub
/script>
html xmlns="http://www.w3.org/1999/xhtml" >
head id="Head1" runat="server">
title>TemplatePagerField.OnPagerCommand Example/title>
style type="text/css">
body
{
text-align: center;
font: 12px Arial, Helvetica, sans-serif;
}
.item
{
border: solid 1px #2F4F4F;
background: #E6E6FA;
}
/style>
/head>
body>
form id="form1" runat="server">
h3>TemplatePagerField.OnPagerCommand Example/h3>
asp:ListView ID="StoresListView"
DataSourceID="StoresDataSource"
runat="server">
LayoutTemplate>
table width="350" runat="server" id="tblStore">
tr runat="server">
th runat="server">ID/th>
th runat="server">Store Name/th>
/tr>
tr id="itemPlaceholder" runat="server">
/tr>
/table>
/LayoutTemplate>
ItemTemplate>
tr runat="server">
td class="item">
asp:Label ID="IDLabel" runat="server" Text='%#Eval("CustomerID") %>' />
/td>
td align="left" class="item">
asp:Label ID="NameLabel" runat="server" Text='%#Eval("Name")%>' />
/td>
/tr>
/ItemTemplate>
/asp:ListView>
br />
asp:DataPager runat="server"
ID="ContactsDataPager"
PageSize="30"
PagedControlID="StoresListView">
Fields>
asp:TemplatePagerField OnPagerCommand="TemplatePagerField_OnPagerCommand">
PagerTemplate>
asp:LinkButton ID="FirstButton" runat="server" CommandName="First"
Text="" Enabled='%# Container.StartRowIndex > 0 %>' />
asp:LinkButton ID="PreviousButton" runat="server" CommandName="Previous"
Text='%# (Container.StartRowIndex - Container.PageSize + 1) " - " (Container.StartRowIndex) %>'
Visible='%# Container.StartRowIndex > 0 %>' />
asp:Label ID="CurrentPageLabel" runat="server"
Text='%# (Container.StartRowIndex + 1) "-" (IIf(Container.StartRowIndex + Container.PageSize > Container.TotalRowCount, Container.TotalRowCount, Container.StartRowIndex + Container.PageSize)) %>' />
asp:LinkButton ID="NextButton" runat="server" CommandName="Next"
Text='%# (Container.StartRowIndex + Container.PageSize + 1) " - " (IIf(Container.StartRowIndex + Container.PageSize*2 > Container.TotalRowCount, Container.TotalRowCount, Container.StartRowIndex + Container.PageSize*2)) %>'
Visible='%# (Container.StartRowIndex + Container.PageSize) Container.TotalRowCount %>' />
/PagerTemplate>
/asp:TemplatePagerField>
/Fields>
/asp:DataPager>
asp:SqlDataSource ID="StoresDataSource" runat="server"
ConnectionString="%$ ConnectionStrings:AdventureWorks_DataConnectionString %>"
SelectCommand="SELECT [CustomerID], [Name] FROM Sales.Store ORDER BY [Name]">
/asp:SqlDataSource>
/form>
/body>
/html>
您可能感興趣的文章:- asp.net中讓Repeater和GridView支持DataPager分頁(yè)
- asp.net實(shí)現(xiàn)簡(jiǎn)單分頁(yè)實(shí)例
- asp.net gridview分頁(yè)：第一頁(yè) 下一頁(yè) 1 2 3 4 上一頁(yè) 最末頁(yè)
- ASP.NET MVC 5使用X.PagedList.Mvc進(jìn)行分頁(yè)教程(PagedList.Mvc)
- Asp.net GridView使用大全(分頁(yè)實(shí)現(xiàn))
- asp.net中g(shù)ridview的查詢、分頁(yè)、編輯更新、刪除的實(shí)例代碼
- Asp.Net數(shù)據(jù)控件引用AspNetPager.dll分頁(yè)實(shí)現(xiàn)代碼
- asp.net分頁(yè)控件AspNetPager的樣式美化
- ASP.NET 高性能分頁(yè)代碼
