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