Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub tombolEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tombolEdit.Click
- ' perintah = New MySqlCommand("UPDATE pegawai SET (NIK,NamaPegawai) VALUES (@NIK,@NamaPegawai) WHERE (id) VALUES (@id)", koneksi)
- perintah = New MySqlCommand("UPDATE pegawai SET NIK=@NIK, NamaPegawai=@NamaPegawai WHERE id=@id", koneksi)
- perintah.Parameters.AddWithValue("@id", textID.Text)
- perintah.Parameters.AddWithValue("@NIK", textNIKPegawai.Text)
- perintah.Parameters.AddWithValue("@NamaPegawai", textNamaPegawai.Text)
- koneksi.Open()
- perintah.ExecuteNonQuery()
- koneksi.Close()
- koneksi.Dispose()
- textID.Text = ""
- textNIKPegawai.Text = ""
- textNamaPegawai.Text = ""
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement