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/
 


Kirim email ke