高清狠狠综合久久久久精品网站,丝瓜视频黄色免费网站,天堂aV黄色在线观看

當(dāng)前位置：首頁(yè) > 范文|應(yīng)用文 > IT技術(shù)專欄 > 網(wǎng)絡(luò)編程

淺談VS中的DataPager分頁(yè)

來(lái)源：易賢網(wǎng) 閱讀：1733 次日期：2015-02-27 10:58:43

溫馨提示：易賢網(wǎng)小編為您整理了“淺談VS中的DataPager分頁(yè)”,方便廣大網(wǎng)友查閱！

微軟的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 顯示模式:

淺談VS中的DataPager分頁(yè)

webForm下的樣式由TemplatePagerField，NextPreviousPagerField和NumericPagerField控制

通過(guò)設(shè)置上面幾個(gè)控件的配合也可以達(dá)到winForm下的效果，這3個(gè)控件中最重要的是TemplatePagerField控件。

下面簡(jiǎn)單看看TemplatePagerField控件可以怎么設(shè)置：

代碼如下:

<%@ Page language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"">

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>

<title>TemplatePagerField.OnPagerCommand Example</title>

body

{

text-align: center;

font: 12px Arial, Helvetica, sans-serif;

}

.item

{

border: solid 1px #2F4F4F;

background: #E6E6FA;

}

</style>

</head>

<body>

<h3>TemplatePagerField.OnPagerCommand Example</h3>

<asp:ListView ID="StoresListView"

DataSourceID="StoresDataSource"

runat="server">

<th runat="server">Store Name</th>

</tr>

</tr>

</table>

</LayoutTemplate>

<asp:Label ID="IDLabel" runat="server" Text='<%#Eval("CustomerID") %>' />

</td>

<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">

<asp:TemplatePagerField OnPagerCommand="TemplatePagerField_OnPagerCommand">

<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>