ASP.NET GridView Hyperlink Column + ItemTemplate 使用方法
Default.aspx |
<asp:GridView ID="GridView1" AutoGenerateColumns="false" runat="server"> <Columns> <asp:TemplateField HeaderText="League ID"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("League ID") %>' /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="League Name"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("League Name") %>' /> </ItemTemplate> </asp:TemplateField> <asp:HyperLinkField HeaderText="Link" DataNavigateUrlFields="League ID" DataNavigateUrlFormatString="WebForm2.aspx?id={0}" Text="Click Me" /> </Columns> </asp:GridView> |
Default.aspx.vb |
Private Sub GetInfo() Dim connectionString1 As New StringBuilder connectionString1.Append("Data Source=.\SqlExpress; ") connectionString1.Append("Initial Catalog=Soccer; ") connectionString1.Append("Integrated Security=SSPI") Dim con1 As SqlConnection = New SqlConnection(connectionString1.ToString) con1.Open() Dim SqlString1 As New StringBuilder SqlString1.Append("SELECT League_ID AS 'League ID', ") SqlString1.Append("League_Name AS 'League Name' FROM dbo.League") Dim cmd1 As SqlCommand = New SqlCommand(SqlString1.ToString, con1) Dim dr As SqlDataReader = cmd1.ExecuteReader() Dim LeagueDataTable As New DataTable LeagueDataTable.Load(dr) GridView1.DataSource = LeagueDataTable GridView1.DataBind() dr.Dispose() cmd1.Dispose() con1.Dispose() End Sub |