Well here it is, im using list view box and MSAccess as Database
connection
rs.Open " SELECT * FROM Menu WHERE Menu_ID=" & tmp, con, 3, 3
rs.Update
txtname.Text = rs("Name")
txtprc.Text = rs("Price")
txtqnt.Text = rs("Quantity")
rs.Update
clos
MsgBox "Updated Successfully!", vbInformation, Me.Caption
Form_Load
txtname.Text = ""
txtprc.Text = ""
txtqnt.Text = ""
End Sub
This was the code given i use last year, but right now it won't work. and i just want to add that if you click the item on the list view and click edit it will automatically appear on the text boxes, where i will edit the content in the list view. and press edit again to update it. I hope someone is familiar with this code,
cause I lost the code for what i have said above. this was the old code we use in our class last year.