跳转到第几页
public
void
TemplatePagerField_OnPagerCommand(
object
sender, DataPagerCommandEventArgs e)
{
switch (e.CommandName)
{
case "abc":
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;
}
}
{
switch (e.CommandName)
{
case "abc":
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;
}
}
<
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 >
</ 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 >
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 >
</ 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 >
要是数据量大时,感效率不高