.3.5 DataPager 分页

       
          跳转到第几页

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

  
 

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

 
  要是数据量大时,感效率不高