Improve this question. Francisco 9, 4 4 gold badges 32 32 silver badges 42 42 bronze badges. Martin Baraza Martin Baraza 21 3 3 bronze badges. Add a comment. Active Oldest Votes. Text con. AddWithValue " Surname", txtsurname. AddWithValue " Residence", txtresidence. AddWithValue " Email", txtemail.
Text End With MysqlConn. Open con. Message End Try End Sub. Improve this answer. Thanks for the reply. The code has helped but now there's another problem. When I open localhost to check if it has done the update I see the entire fields for one record deleted. Wish I could attached a screenshot here but unfortunately I can't because I don't have enough reputations to do so according to the site — Martin Baraza.
Are you saying that the entire fields became empty string? If so, try to check if the values of txtemployeeid. Text , txtnatid. Text etc are empty. Yes the fields are empty. Just some guy Just some guy 1, 4 4 gold badges 20 20 silver badges 30 30 bronze badges. Have you tried writing SQL trigger? You need to define it to update column with datetime of update on update of other columns — Misa Lazovic.
Add a comment. Active Oldest Votes. Improve this answer. Raad Raad 4, 2 2 gold badges 22 22 silver badges 41 41 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.
The Overflow Blog. Klik nama tabel pada sidebar pada sidebar kiri, lalu klik tulisan "Edit" pada isi data. Tags Pengetahuan Tutorial. Labels: Pengetahuan , Tutorial. Join now!!! October 29, at PM. Newer Post Older Post Home. Subscribe to: Post Comments Atom. Temukan Artikel. Powered by Blogger. Tags Pengetahuan Tutorial Trik Sejarah.
0コメント