pasti bisa ... di stored procedurnya kasih parameter
contoh :
create procedure NamaProcedure
(
@No as varchar
)
AS
Update TabelKu Set Nama = 'Tessss' where [EMAIL PROTECTED]
GO
code VB nya
KoneksiDatabase.exec NamaProcedure,'parameter'
----- Original Message -----
From: Bagus Wicaksono
To: indoprog-vb@yahoogroups.com
Sent: Friday, April 15, 2005 4:19 PM
Subject: Re: [indoprog-vb] Mengakses store procedure dari vb
Maaf nih Pak Arief.. mo nanya lagi nih..
Bagaimana kalau nilai dari store procedure kita ingin masukkan dari textbox
yang kita buat di VB (pada saat select,update atau delete), bisa tidak ya...
bagaimana caranya ???
terima kasih banyak ya pak
Bagus w
arief <[EMAIL PROTECTED]> wrote:
cara yang paling mudah :
Dim KoneksiDatabase as ADODB.Recordset
KoneksiDatabase.connectionstring=" Driver={SQL Server};SERVER=" & namaserver
& ";UID=&" KodeUser & ";PWD=" & Password & ";DATABASE=databaseku;"
koneksidatabase.open
KoneksiDatabase.exec "[nama Stored procedure]"
Thank's
Arief
---- Original Message -----
From: Bagus Wicaksono
To: indoprog-vb@yahoogroups.com
Sent: Friday, April 15, 2005 2:25 PM
Subject: [indoprog-vb] Mengakses store procedure dari vb
Bagaimana ya cara mengakses store procedure yang kita punya dari vb.
Misalnya kita punya database dengan nama "databaseku" dan kita punya tabel yang
bernama "tabelku" dengan field2 : no,nama,alamat. Query store procedurenya :
"select * from tabelku". Bagaimana cara untuk mengakses store procedure
tersebut dari vb ya...
Terimakasih banyak sekali atas informasi dan pencerahannya....
Bagus
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
[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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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 the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
[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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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/
