how to delete data

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • prigupta2
    New Member
    • Oct 2008
    • 33

    #1

    how to delete data

    frontend vb6.0
    backend Ms Aaccess
    how to delete data from database
    connection "adodc"
  • lee123
    Contributor
    • Feb 2007
    • 556

    #2
    hello there,

    try this:


    make a command button name it "Delete"
    then inside of the button enter in this code.


    Code:
    Adodc1.Recordset.Delete
    Adodc1.Recordset.Movenext
    lee123

    if this doesn't work reply.

    Comment

    • prigupta2
      New Member
      • Oct 2008
      • 33

      #3
      Originally posted by lee123
      hello there,

      try this:


      make a command button name it "Delete"
      then inside of the button enter in this code.


      Code:
      Adodc1.Recordset.Delete
      Adodc1.Recordset.Movenext
      lee123

      if this doesn't work reply.
      it words but i want to delete perticular data show in "DataGrid1"
      whwn i click on it data will appears in textboxes but it can't delete
      errorRuntime error '-214721887(80040 e21)'
      multiple-step operation generated error.Check each statement value

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        you need to pass the value in the textbox as parameter to database for delete.

        Comment

        Working...