Kalo seperti ini.... gimana ? coba anda bandingkan
mana yg lebih simpel
-------------------------------------------
'Deklarasi variabel koneksi
Dim CN As New ADODB.Command
'Buat koneksi ke server
CN.ActiveConnection="Provider=SQLOLEDB.1;Persist
Security Info=False;User ID=sa;Initial
Catalog=DBPersonalia;Data Source=192.168.0.1"
'Saving Ke Tabel
CN.ActiveConnection.BeginTrans
CN.CommandType = adCmdStoredProc
CN.CommandText="SP_ADD_TABELKU"
CN.Parameters("@pro") = MyVariable
CN.Parameters("@Department") = MyVariable
CN.Parameters("@Department1") = MyVariable
CN.Execute
CN.ActiveConnection.CommitTrans
'Tutup Koneksi
CN.Close
---------------------------------------
Lebih simpel dan hasilnya sama untuk menyimpan data ke
tabel serta lebih ringkas codingnya
dan juga lebih irit memory
Kalo dipasangkan ke form, koneksi sekali aja waktu
load
dan close waktu Unload
semoga membantu
.oO Khoirul Imam M Oo.
__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-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/
