Use asp:HyperlinkColumn and asp:ButtonColumn in asp:DataGrid (VB.net) : DataGrid « ASP.net Controls « ASP.NET Tutorial






  1. ASP.NET Tutorial
  2. ASP.net Controls
  3. DataGrid
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="VB" runat="server">
   sub Page_Load(Sender as Object, e as EventArgs) 
      dim myConnection as new OleDbConnection( _
            "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
            & "DATA SOURCE=" _
            & Server.MapPath("EmployeeDatabase.mdb;"))

      dim myCommand as new OleDbDataAdapter("select * from employee", myConnection)

      dim ds as DataSet = new DataSet()
      myCommand.Fill(ds, "employee")

      DataGrid1.DataSource = ds.Tables("employee").DefaultView
      DataBind()
   end sub
   
   sub DataGrid1_ItemCommand(obj as object, e as _
      DataGridCommandEventArgs)
      DataGrid1.SelectedIndex = e.Item.ItemIndex
      DataBind()
   end sub
</script>

<body>
   <form runat="server">
      <asp:DataGrid id="DataGrid1" runat="server"
        BorderColor="black"
        GridLines="Vertical"
        cellpadding="4"
        cellspacing="0"
        width="450"
        Font-NameFont-Names="Arial"
        Font-Size="8pt"
        ShowFooter="True"
        HeaderStyle-BackColor="#cccc99"
        FooterStyle-BackColor="#cccc99"
        ItemStyle-BackColor="#ffffff"
        AlternatingItemStyle-Backcolor="#cccccc"
        AutoGenerateColumns="false">
        <Columns>
            <asp:TemplateColumn HeaderText="Name">
                  <ItemTemplate>
                        <asp:Label id="Name" runat="server"
                              Text='<%# Container.DataItem("FirstName")& _
                               " " & Container.DataItem("LastName") %>'/>
                  </ItemTemplate>
            </asp:TemplateColumn>
  
            <asp:BoundColumn HeaderText="ID" DataField="ID"/>
  
            <asp:HyperlinkColumn HeaderText="Edit" text="Edit" NavigateURL="edit.aspx"/>
  
            <asp:ButtonColumn HeaderText="Delete?" text="X" CommandName="delete" ButtonType="PushButton"/>
  
        </Columns>
  </asp:DataGrid>
   </form>
   
</body>
</html>








3.37.DataGrid
3.37.1.DataGrid Data Binding
3.37.2.Use asp:DataGrid to edit data in an Access table (VB.net)
3.37.3.Use asp:HyperlinkColumn and asp:ButtonColumn in asp:DataGrid (VB.net)
3.37.4.asp:EditCommandColumn in asp:DataGrid (VB.net)
3.37.5.Bind data of directories to asp:DataGrid (VB.net)
3.37.6.Bind file information to asp:DataGrid (VB.net)
3.37.7.Binding DataReader to DataGrid