need help about update

Erdinc Kolukisa

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka15y ago
Accepted answer
            con.Open();
SqlConnection con = new SqlConnection("Data Source=MYDataSource;Initial Catalog=DB;User ID=Sa;Password=sa123"); //The connection of ur sql

            SqlCommand cmd = new SqlCommand("HostGuncelle", con);//Stored procedure name
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@_id ", SqlDbType.int);
            cmd.Parameters.Add("@_isim", SqlDbType.nVarChar, 50);
//Declare all your Values as per the Storedprocedure this should match the stored Procedure values

Later
Declare some strings and assign the needed values to those string

ex: string ID=textbox1.text some thing like this add all your needed ones

cmd.Parameters["@_id"].Value = ID;

//Add each and every paramters like the above

            cmd.ExecuteNonQuery();
            con.Close();
0
Dorababu Meka15y ago
Are you having idea om 3 tier architecture if so write all the code in the class and call the method from the class so that it will be good
0
Erdinc Kolukisa15y ago
thanks for your reply.. i did as u said like below..and it works
HostingForm hostForm = (HostingForm)Application.OpenForms["HostingForm"];
cmmd = d.HostGuncelle();
cmmd.Parameters.AddWithValue("@_id", SqlDbType.Int);
cmmd.Parameters["@_id"].Value = Convert.ToInt32(hostForm.dataGridView1.Rows[hostForm.dataGridView1.CurrentRow.Index].Cells[1].Value.ToString());
cmmd.Parameters.AddWithValue("@_isim", SqlDbType.NVarChar);
cmmd.Parameters["@_isim"].Value = hostForm.txtAd.Text;
cmmd.Parameters.AddWithValue("@_ip", SqlDbType.NVarChar);
cmmd.Parameters["@_ip"].Value = hostForm.txtIpAdresi.Text;
cmmd.Parameters.AddWithValue("@_ns", SqlDbType.NVarChar);
cmmd.Parameters["@_ns"].Value = hostForm.txtNs.Text;
cmmd.Parameters.AddWithValue("@_tur", SqlDbType.NVarChar);
cmmd.Parameters["@_tur"].Value = hostForm.cmbTur.Text;
cmmd.Parameters.AddWithValue("@_tip", SqlDbType.NVarChar);
cmmd.Parameters["@_tip"].Value = hostForm.cmbTip.Text;
cmmd.Parameters.AddWithValue("@_odeme", SqlDbType.NVarChar);
cmmd.Parameters["@_odeme"].Value = hostForm.txtOdeme.Text;
cmmd.Parameters.AddWithValue("@_sshKa", SqlDbType.NVarChar);
cmmd.Parameters["@_sshKa"].Value = hostForm.txtSSh.Text;
cmmd.Parameters.AddWithValue("@_sshSifre", SqlDbType.NVarChar);
cmmd.Parameters["@_sshSifre"].Value = hostForm.txtSSHSifre.Text;
cmmd.Parameters.AddWithValue("@_panelKa", SqlDbType.NVarChar);
cmmd.Parameters["@_panelKa"].Value = hostForm.txtPanel.Text;
cmmd.Parameters.AddWithValue("@_panelSifre", SqlDbType.NVarChar);
cmmd.Parameters["@_panelSifre"].Value = hostForm.txtPanelSifre.Text;
cmmd.Parameters.AddWithValue("@_bayiKa", SqlDbType.NVarChar);
cmmd.Parameters["@_bayiKa"].Value = hostForm.txtBayi.Text;
cmmd.Parameters.AddWithValue("@_bayiSifre", SqlDbType.NVarChar);
cmmd.Parameters["@_bayiSifre"].Value = hostForm.txtBayiSifre.Text;
cmmd.Parameters.AddWithValue("@_PmaAdres", SqlDbType.NVarChar);
cmmd.Parameters["@_PmaAdres"].Value = hostForm.txtPma.Text;
cmmd.Parameters.AddWithValue("@_PmaKullanici", SqlDbType.NVarChar);
cmmd.Parameters["@_PmaKullanici"].Value = hostForm.txtPmaKa.Text;
cmmd.Parameters.AddWithValue("@_PmaSifre", SqlDbType.NVarChar);
cmmd.Parameters["@_PmaSifre"].Value = hostForm.txtPmaSifre.Text;
cmmd.Parameters.AddWithValue("@_webmail", SqlDbType.NVarChar);
cmmd.Parameters["@_webmail"].Value = hostForm.txtWebmail.Text;
cmmd.Parameters.AddWithValue("@_aciklama", SqlDbType.NVarChar);
cmmd.Parameters["@_aciklama"].Value = hostForm.txtAciklama.Text;
return cmmd.ExecuteNonQuery();
do u think it is good technique? because i made all controls' modifiers as public then i could reach them over another class..i have Hosting class that includes all these values..so could i use it ?
thanks for your help
0
Erdinc Kolukisa15y ago
yeah man u got it right..i wrote my stored procedure but i dont know how i will use it in my program
0
Dorababu Meka15y ago
Still i did not get you... What i think is u want to use that stored procedure from coding side or what
0
Erdinc Kolukisa15y ago
hey thanks for reply..
i can add delete or something like that in my program..
but i dont know the logic of update statement..
i am trying to make multilayer programming to learn it.. i cant know the logic what should i return from my DataAccess layer and ProcessLayeri need help like that things
0
Dorababu Meka15y ago
What exactly you need i did not understand can you please more specific about your problem
0