asp:EditCommandColumn 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
      DataGrid1.DataMember = "employee"
      DataBind()
   end sub
   
   sub DataGrid1_Edit(Sender as Object, e as DataGridCommandEventArgs)
      DataGrid1.EditItemIndex = e.Item.ItemIndex
      DataGrid1.DataBind()
   end sub

   sub DataGrid1_Update(Sender as Object, e as DataGridCommandEventArgs)
      DataGrid1.DataBind()
   end sub

   sub DataGrid1_Cancel(Sender as Object, e as DataGridCommandEventArgs)
      DataGrid1.EditItemIndex = -1
      DataGrid1.DataBind()
   end sub
   
   sub DataGrid1_SortCommand(Sender as Object, e as DataGridSortCommandEventArgs)
      DataGrid1.DataBind()
   End Sub

   sub DataGrid1_PageIndexChanged(Sender as Object, e as DataGridPageChangedEventArgs)
      DataGrid1.CurrentPageIndex = e.NewPageIndex
      DataGrid1.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"
        AllowSorting=true
        OnEditCommand="DataGrid1_Edit"
        OnCancelCommand="DataGrid1_Cancel"
        OnUpdateCommand="DataGrid1_Update"
        AllowPaging="True"
        PageSize=2
        PagerStyle-Mode=NumericPages
        PagerStyle-PageButtonCount = 2
        OnPageIndexChanged="DataGrid1_PageIndexChanged" >
  
        <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:EditCommandColumn
                 EditText="Edit"
                 CancelText="Cancel"
                 UpdateText="Update"
                 ItemStyle-Wrap="false"
                 HeaderText="Edit" />

        </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