المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : something wrong in codes



C# Programming
01-01-2010, 12:21 PM
hi coders
i have a problem about my codes
let me tell the scenario first...i have two Forms(frm1 and frm2)...i opened frm2 by clicking a button on frm1..there is no problem till here...i want to save informations by filling the blanks on frm2 and save it but when i click save button there is nothing happen..here are my codes.. i couldnt see anything wrong in my connection or in my insert command...i need help about it

try
{
con = new SqlConnection("data source=Erdal2\\SQLEXPRESS;initial catalog=Medya;integrated security=true");

cmd = new SqlCommand("insert into Rehber (ad,soyad,firma,sektor,grup,cep_no,is_no,ev_no,fax,mail,web,msn,skype,dgm_tarih,adres,ilce,sehir,ver gi_no,vrgi_daire) values (@ad,@soyad,@firma,@sektor,@grup,@cep_no,@is_no,@ev_no,@fax,@mail,@web,@msn,@skype,@dgm_tarih,@adres ,@ilce,@sehir,@vergi_no,@vrgi_daire)", con);

con.Open();

cmd.Parameters.Add("@ad", SqlDbType.NVarChar).Value = txtAd.Text;
cmd.Parameters.Add("@soyad", SqlDbType.NVarChar).Value = txtSoyad.Text;
cmd.Parameters.Add("@firma", SqlDbType.NVarChar).Value = cmbFirma.SelectedItem;
cmd.Parameters.Add("@sektor", SqlDbType.NVarChar).Value = cmbSektor.SelectedItem;
cmd.Parameters.Add("@grup", SqlDbType.NVarChar).Value = txtGrup.Text;
cmd.Parameters.Add("@cep_no", SqlDbType.NVarChar).Value = txtCep.Text;
cmd.Parameters.Add("@is_no", SqlDbType.NVarChar).Value = txtisTlf.Text;
cmd.Parameters.Add("@ev_no", SqlDbType.NVarChar).Value = txtEvTlf.Text;
cmd.Parameters.Add("@fax", SqlDbType.NVarChar).Value = txtFax.Text;
cmd.Parameters.Add("@mail", SqlDbType.NVarChar).Value = txtMail.Text;
cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = txtURL.Text;
cmd.Parameters.Add("@msn", SqlDbType.NVarChar).Value = txtMSn.Text;
cmd.Parameters.Add("@skype", SqlDbType.NVarChar).Value = txtSkype.Text;
cmd.Parameters.Add("@dgm_tarih", SqlDbType.SmallDateTime).Value = dateTimePicker1.Value;
cmd.Parameters.Add("@adres", SqlDbType.NVarChar).Value = txtAdres.Text;
cmd.Parameters.Add("@ilce", SqlDbType.NVarChar).Value = txtIlce.Text;
cmd.Parameters.Add("@sehir", SqlDbType.NVarChar).Value = txtSehir.Text;
cmd.Parameters.Add("@vergi_no", SqlDbType.NVarChar).Value = txtVergiNo.Text;
cmd.Parameters.Add("@vrgi_daire", SqlDbType.NVarChar).Value = txtVergiDaire.Text;

if ((txtAd.Text != "") || (txtSoyad.Text != ""))
{
if (cmd.ExecuteNonQuery() == 1)

MessageBox.Show("Done", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
else
MessageBox.Show("Error during saving processes","Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
MessageBox.Show("There must be name and surname entered","warning",MessageBoxButtons.OK,MessageBoxIcon.Error);

i declared con and cmd as global variables...