need help about update

Erdinc Kolukisa

Jan 10 2011 10:02 AM

3.2k

i want to update my datas thatbelongs to my Hosting class ..i wrote a stored proc for it like that ALTER proc [dbo].[sp_HostGuncelle]

(

@_id int,

@_isim nvarchar(50),

@_ip nvarchar(30),

@_ns nvarchar(30),

@_tur nvarchar(30),

@_tip nvarchar(30),

@_odeme nvarchar(30),

@_sshKa nvarchar(30),

@_sshSifre nvarchar(30),

@_panelKa nvarchar(30),

@_panelSifre nvarchar(30),

@_bayiKa nvarchar(30),

@_bayiSifre nvarchar(30),

@_PmaAdres nvarchar(30),

@_PmaKullanici nvarchar(30),

@_PmaSifre nvarchar(30),

@_webmail nvarchar(30),

@_aciklama nvarchar(30)

)

Begin

Update Hosting Set isim=@_isim,ip_adresleri=@_ip,ns=@_ns, tur=@_tur, tip=@_tip, odeme=@_odeme, sshKa=@_sshKa, sshSifre=@_sshSifre, panelKa=@_panelKa, panelSifre=@_panelSifre, bayiKa=@_bayiKa, bayiSifre=@_bayiSifre, pmaAdres=@_PmaAdres, pmaKullanici=@_PmaKullanici, pmaSifre=@_PmaSifre, webmail=@_webmail, aciklama=@_aciklama

Where id=@_id

End

but i dont know how to realize it in program side..anyone who can show some sample codes about it pls