need help about update

Jan 10 2011 10:02 AM
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)
)
as 
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 

Answers (7)