ASP.NET GridView Hyperlink Column + ItemTemplate 使用方法

 
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