SQLDataSource + GridView + ItemTemplate + Paging 使用方法

 
SQLDataSource + GridView + ItemTemplate + Paging 使用方法
 

   Default.aspx
 
   <asp:SqlDataSource ID="SqlDataSource1" runat="server"
   ConnectionString="Data Source=.\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI"
   SelectCommand="SELECT 'http://hk.yahoo.com/&#039; AS 'ComLink',
   'http://l.yimg.com/mq/i/auc/pyhk_mh_auctions.png&#039; AS 'Link', * FROM dbo.Result_View;" />
 
   <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
   AllowPaging="true" AutoGenerateColumns="false" PageSize="5">
      <Columns>
 
         <asp:ImageField DataImageUrlField="Link" HeaderText="Image" />
 
         <asp:TemplateField HeaderText="Image Link">
            <ItemTemplate>
               <a href='<%# Eval("ComLink") %>'>
               <asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("Link") %>' />
               </a>
            </ItemTemplate>
         </asp:TemplateField>
 
         <asp:TemplateField HeaderText="Player">
            <ItemTemplate>
               <asp:Label ID="Label1" runat="server"
               Text='<%# Eval("Player") %>' />
            </ItemTemplate>
         </asp:TemplateField>
 
         <asp:TemplateField HeaderText="Team">
            <ItemTemplate>
               <asp:Label ID="Label2" runat="server"
               Text='<%# Eval("Team") %>' />
            </ItemTemplate>
         </asp:TemplateField>
 
         <asp:TemplateField HeaderText="League">
            <ItemTemplate>
               <asp:Label ID="Label3" runat="server"
               Text='<%# Eval("League") %>' />
            </ItemTemplate>
         </asp:TemplateField>
 
      </Columns>
   </asp:GridView>