SQLDataSource + ListView + DataPager 使用方法

 
SQLDataSource + ListView + DataPager 使用方法
 

   Default.aspx
 
   <asp:SqlDataSource ID="SqlDataSource1" runat="server"
   ConnectionString="Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI"
   SelectCommand="SELECT * FROM dbo.Result_View;" />
 
   <asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1">
 
      <ItemTemplate>
         <span style="">Player:
            <asp:Label ID="PlayerLabel" runat="server" Text='<%# Eval("Player") %>' />
            <br />
            Team:
            <asp:Label ID="TeamLabel" runat="server" Text='<%# Eval("Team") %>' />
            <br />
            League:
            <asp:Label ID="LeagueLabel" runat="server" Text='<%# Eval("League") %>' />
            <br />
            <br />
         </span>
      </ItemTemplate>
 
      <LayoutTemplate>
         <div ID="itemPlaceholderContainer" runat="server" style="">
            <span runat="server" id="itemPlaceholder" />
         </div>
         <div style="">
            <asp:DataPager ID="DataPager1" runat="server" PageSize="1">
            <Fields>
            <asp:NextPreviousPagerField
            ShowFirstPageButton="true" FirstPageText="First"
            ShowLastPageButton="true" LastPageText="Last"
            ShowNextPageButton="true" NextPageText="Next"
            ShowPreviousPageButton="true" PreviousPageText="Previous" />
            </Fields>
            </asp:DataPager>
         </div>
      </LayoutTemplate>
 
   </asp:ListView>