Setelah sql-nya didefinisikan di eksekusi dong Mas...
Public db As New ADODB.Connection
strKoneksi = "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data
Source=NAMADSN"
db.Open strKoneksi
strsql = "update parkir set tanggalkeluar='" & v_tanggal & "' ,jamkeluar =
'" & v_jam & "' ,lamawaktu = " & lama_waktu & ", hargajam1 = " & vs_jamsatu
& ", hargajamberikut = " & vs_jamdua & ", totalharga = " & totharga &
",urut_keluar = " & no_urut & ", selesai = 'S' where nomobil = '" &
txtNOPOL.Text & "' and selesai = 'B' "
db.execute strsql
Contoh diatas pake MySQL. dengan koneksi pake ODBC
Yassir Ismail <[EMAIL PROTECTED]> wrote: Saya pemula di vb6 mo Tanya
nich....
Bagaimana cara meng-update record pake ADO, saya pake SQL statement kok gak
ke-update ya berikut ini listingnya :
strsql = "update parkir set tanggalkeluar='" & v_tanggal & "' ,jamkeluar =
'" & v_jam & "' ,lamawaktu = " & lama_waktu & ", hargajam1 = " & vs_jamsatu
& ", hargajamberikut = " & vs_jamdua & ", totalharga = " & totharga &
",urut_keluar = " & no_urut & ", selesai = 'S' where nomobil = '" &
txtNOPOL.Text & "' and selesai = 'B' "
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
SPONSORED LINKS
Computer internet security
Computer internet business
Computer internet access
Computer internet privacy securities
Computer internet help
Computer internet connection
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indoprog-vb" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
[Non-text portions of this message have been removed]
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
