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/' AS 'ComLink', 'http://l.yimg.com/mq/i/auc/pyhk_mh_auctions.png' 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> |