misal mau mengupdate nama_pelanggan di tabel pelanggan
stored procedurenya:
CREATE PROCEDURE SP_UpdateNama
@ID_Plg Varchar(100), @Nama_Plg Varchar(100)
AS
UPDATE Pelanggan SET nama_pelanggan = @Nama_Plg
WHERE id_pelanggan = @ID_Plg
GO
karena stored procedurenya minta 2 parameter maka VB -nya harus
memberikan 2 parameter juga
dim Cn as new.adodb connection
dim ID as string
dim Nama as string
ID = "A001"
Nama = "UCHENK BIN WADHER"
Cn.Open "Provider=........."
Cn.Execute "EXEC SP_UpdateNama '" & ID &"', '"& Nama &"'"
semoga membantu
--- In [email protected], uchenk dodit <[EMAIL PROTECTED]>
wrote:
>
> terimakasih pak cahyo
> sebelumnya terimakasih
>
> klo dengan paramater bagaimana ya misalnya :
>
> where id_plg = @par_id
>
>
> bagaimana ya pak mohon pencerahannya
> terimakasih
>
> simbok_cahyo <[EMAIL PROTECTED]>
wrote: Misal stored procedure utk
simpan :
>
> CREATE PROCEDURE SP_Simpan
> @NilaiSimpan Int
>
> AS
>
> INSERT INTO Table1 VALUES @NilaiSimpan
>
> GO
>
> trus utk manggil dari vb:
>
> dim Cn as new.adodb connection
> dim Nilai as integer
>
> Nilai = 1
> Cn.Open "Provider=........."
> Cn.Execute "EXEC SP_Simpan " & Nilai
>
> semoga membantu
>
> --- In [email protected], uchenk dodit <firman_sys@>
> wrote:
> >
> > hi para programmer
> indonesia......
> > saya minta pencerahannya dong untuk buat store procedure
> simpan,edit,delete. Yang nantinya di panggil lewat VB.Klo bisa
> minta sample nya dari VB dan store procedurenya.
> >
> > mohon bantuannya ya........
> > terimakasih banyak sebelumya
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Want to start your own business? Learn how on Yahoo! Small
> Business.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> ---------------------------------
> Low, Low, Low Rates! Check out Yahoo! Messenger's cheap PC-to-
Phone call rates.
>
> [Non-text portions of this message have been removed]
>
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Bagi terjangkit virus lokal, zip virus tersebut
dan kirim ke [EMAIL PROTECTED], kami
akan membuat removalnya untuk anda.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-vb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indoprog-vb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
