Use-OnItemCommand-OnEditCommand-OnCancelCommand-OnUpdateCommand-OnDeleteCommand-for-asp


            <%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

   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")
      DataList1.DataSource = ds.Tables("employee").DefaultView
      DataBind()
   end sub
   
   sub DataList1_ItemCommand(Sender as object, e as DataListCommandEventArgs)
      DataList1.SelectedIndex = e.Item.ItemIndex
      DataList1.DataBind()
   end sub
   sub DataList1_EditCommand(Sender as object, e as DataListCommandEventArgs)
      DataList1.EditItemIndex = e.Item.ItemIndex
      DataList1.DataBind()
   end sub
   
   sub DataList1_CancelCommand(Sender as object, e as DataListCommandEventArgs)
      DataList1.EditItemIndex = -1
      DataList1.DataBind()
   end sub
   sub DataList1_UpdateCommand(Sender as object, e as DataListCommandEventArgs)
      DataList1.DataBind()
   end sub
   sub DataList1_DeleteCommand(Sender as object, e as DataListCommandEventArgs)
      DataList1.DataBind()
   end sub


   
         SelectedItemStyle-BackColor="#cccc99"
      repeatlayout="table"
      repeatdirection="horizontal"
      OnItemCommand="DataList1_ItemCommand"
      OnEditCommand="DataList1_EditCommand"
      OnCancelCommand="DataList1_CancelCommand"
      OnUpdateCommand="DataList1_UpdateCommand"
      OnDeleteCommand="DataList1_DeleteCommand"
      DataKeyField="ID">
      
                     Text='<%# Container.DataItem("FirstName") & " " & _
               Container.DataItem("LastName") %>'
            CommandName="Edit" />
         
      
      
         <%# Container.DataItem("FirstName") & " " & _
            Container.DataItem("LastName") %>

         ID:
         <%# Container.DataItem("ID") %>
         

      
      
      
                     CommandName="Cancel"
            Text="Cancel" />
                     CommandName="Update"
            Text="Update" />
                     CommandName="Delete"
            Text="Delete" />
ASP Net Controls ASP.Net Tutorial
