跳转到第几页
public void TemplatePagerField_OnPagerCommand(object sender, DataPagerCommandEventArgs e)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
switch (e.CommandName)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
case "abc":
![](/Images/OutliningIndicators/InBlock.gif)
TextBox index = (TextBox)(e.Item.FindControl("All"));
e.NewStartRowIndex = e.Item.Pager.PageSize*(int.Parse (index.Text)-1);
e.NewMaximumRows = e.Item.Pager.MaximumRows;
break;
}
}
![](/Images/OutliningIndicators/None.gif)
<asp:ListView ID="ListView1" runat="server" DataKeyNames="CustomerID"
DataSourceID="SqlDataSource1">
<AlternatingItemTemplate>
<tr style="background-color: #FAFAD2;color: #284775;">
<td>
<asp:Label ID="CustomerIDLabel" runat="server"
Text='<%# Eval("CustomerID") %>' />
</td>
<td>
<asp:Label ID="CompanyNameLabel" runat="server"
Text='<%# Eval("CompanyName") %>' />
</td>
<td>
<asp:Label ID="ContactNameLabel" runat="server"
Text='<%# Eval("ContactName") %>' />
</td>
<td>
<asp:Label ID="ContactTitleLabel" runat="server"
Text='<%# Eval("ContactTitle") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
<td>
<asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table ID="itemPlaceholderContainer" runat="server" border="1"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color: #FFFBD6;color: #333333;">
<th runat="server">
CustomerID</th>
<th runat="server">
CompanyName</th>
<th runat="server">
ContactName</th>
<th runat="server">
ContactTitle</th>
<th runat="server">
Address</th>
<th runat="server">
City</th>
</tr>
<tr ID="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server"
style="text-align: center;background-color: #FFCC66;font-family: Verdana, Arial, Helvetica, sans-serif;color: #333333;">
</td>
</tr>
</table>
</LayoutTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert"
Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Clear" />
</td>
<td>
<asp:TextBox ID="CustomerIDTextBox" runat="server"
Text='<%# Bind("CustomerID") %>' />
</td>
<td>
<asp:TextBox ID="CompanyNameTextBox" runat="server"
Text='<%# Bind("CompanyName") %>' />
</td>
<td>
<asp:TextBox ID="ContactNameTextBox" runat="server"
Text='<%# Bind("ContactName") %>' />
</td>
<td>
<asp:TextBox ID="ContactTitleTextBox" runat="server"
Text='<%# Bind("ContactTitle") %>' />
</td>
<td>
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
</td>
<td>
<asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' />
</td>
</tr>
</InsertItemTemplate>
<SelectedItemTemplate>
<tr style="background-color: #FFCC66;font-weight: bold;color: #000080;">
<td>
<asp:Label ID="CustomerIDLabel" runat="server"
Text='<%# Eval("CustomerID") %>' />
</td>
<td>
<asp:Label ID="CompanyNameLabel" runat="server"
Text='<%# Eval("CompanyName") %>' />
</td>
<td>
<asp:Label ID="ContactNameLabel" runat="server"
Text='<%# Eval("ContactName") %>' />
</td>
<td>
<asp:Label ID="ContactTitleLabel" runat="server"
Text='<%# Eval("ContactTitle") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
<td>
<asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' />
</td>
</tr>
</SelectedItemTemplate>
<EmptyDataTemplate>
<table runat="server"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
<tr>
<td>
No data was returned.</td>
</tr>
</table>
</EmptyDataTemplate>
<EditItemTemplate>
<tr style="background-color: #FFCC66;color: #000080;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update"
Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Cancel" />
</td>
<td>
<asp:Label ID="CustomerIDLabel1" runat="server"
Text='<%# Eval("CustomerID") %>' />
</td>
<td>
<asp:TextBox ID="CompanyNameTextBox" runat="server"
Text='<%# Bind("CompanyName") %>' />
</td>
<td>
<asp:TextBox ID="ContactNameTextBox" runat="server"
Text='<%# Bind("ContactName") %>' />
</td>
<td>
<asp:TextBox ID="ContactTitleTextBox" runat="server"
Text='<%# Bind("ContactTitle") %>' />
</td>
<td>
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
</td>
<td>
<asp:TextBox ID="CityTextBox" runat="server" Text='<%# Bind("City") %>' />
</td>
</tr>
</EditItemTemplate>
<ItemTemplate>
<tr style="background-color: #FFFBD6;color: #333333;">
<td>
<asp:Label ID="CustomerIDLabel" runat="server"
Text='<%# Eval("CustomerID") %>' />
</td>
<td>
<asp:Label ID="CompanyNameLabel" runat="server"
Text='<%# Eval("CompanyName") %>' />
</td>
<td>
<asp:Label ID="ContactNameLabel" runat="server"
Text='<%# Eval("ContactName") %>' />
</td>
<td>
<asp:Label ID="ContactTitleLabel" runat="server"
Text='<%# Eval("ContactTitle") %>' />
</td>
<td>
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
</td>
<td>
<asp:Label ID="CityLabel" runat="server" Text='<%# Eval("City") %>' />
</td>
</tr>
</ItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand=" select Customers.CustomerID, Customers.CompanyName, Customers.ContactName,
Customers.ContactTitle,
Customers.Address, Customers.City FROM Customers,
Customers a
ORDER BY a.CustomerID">
</asp:SqlDataSource>
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
</div>
<asp:DataPager runat="server" ID="AfterListDataPager"
PagedControlID="ListView1"
PageSize="18">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"
ShowNextPageButton="False" ShowPreviousPageButton="False" />
<asp:NumericPagerField />
<asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True"
ShowNextPageButton="False" ShowPreviousPageButton="False" />
<asp:TemplatePagerField OnPagerCommand="TemplatePagerField_OnPagerCommand">
<PagerTemplate>
<asp:TextBox ID="All" runat="server"></asp:TextBox>
<asp:Button ID="OK" runat="server" Text="abc" CommandName="abc"/>
</PagerTemplate>
</asp:TemplatePagerField>
</Fields>
</asp:DataPager>
![](/Images/OutliningIndicators/None.gif)
要是数据量大时,感效率不高