RE: [Programmer-VB] cara input string

[Nfs, Ibrahim]

Dayat, solusi nya bisa menggunakan parameter.   Di MSSQLServer   Create procedure InputString @Nama varchar (25), @NIP varchar (12) AS                 UPDATE Pegawai SET                 [EMAIL PROTECTED] WHERE                 [EMAIL PROTECTED]   Di VB Private Sub Simpan() Dim Cmd As New ADODB.Command    Cmd.ActiveConnection=<connection>  Cmd.CommandType = adCmdStoredProc  Cmd.CommandText = "InputString"  Cmd.Parameters(0).Value = "asa'at"  Cmd.Parameters(1).Value = "123456"  Cmd.Execute End Sub     Mudah-mudahan bisa membantu. Ibrahim mailto:[EMAIL PROTECTED]   From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gunartha.nyoman Sent: Thursday, June 15, 2006 8:41 AM To: Programmer-VB@yahoogroups.com Subject: Re: [Programmer-VB] cara input string   yth Mas Dayat   untuk asa'at ini kan nama orang. klo saya input di texbot maksudnya dan pada saat saya mau insert or update ke table :     update pegawai set nama = '"& text1.text &  "' where id = 1   dimana isi textbox adalah asa'at   kira-kira ada solusi lain gak ya ?   tks b4 regards Nyoman   ----- Original Message ----- From: dayat To: Programmer-VB@yahoogroups.com Sent: Thursday, June 15, 2006 11:24 AM Subject: Re: [Programmer-VB] cara input string   coba kayak gini: update pegawai set nama = 'asa''at' On 6/15/06, gunartha.nyoman <[EMAIL PROTECTED] > wrote: Dear Miliser VB.   Haii... Saya mo tanya gimana caranya memasukkan data string seperti : asa'at, mu'at ke tabel ms sql   update pegawai set nama = 'asa'at' pasti muncul error     Terima kasih atas bantuannya   Sincerely yours, Nyoman Gunartha Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language   YAHOO! GROUPS LINKS    Visit your group "Programmer-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.   __,_._,__ __._,_.___ Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-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. __,_._,___