private void button1_Click(object sender, EventArgs e) { kullanicilar k = new kullanicilar(); k.tel = textBoxTel.Text; try { SqlConnection con = new SqlConnection("Data Source=ASUSN750JK;Initial Catalog=DemirbasDB;Integrated Security=True"); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "INSERT INTO personelTablo(Ad,Soyad,tel,Il,Adres,kullanıcıAd,kullaniciSifre,Dept) VALUES('" + textBoxAd.Text + "','" + textBoxSoyad.Text + "','" + textBoxTel.Text + "','" + textBoxIl.Text + "','" + textBoxAdres.Text + "','" + textBoxKullaniciAdi.Text + "','" + textBoxSifre.Text + "','" + comboBox1.Text + "')"; cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); con.Close(); MessageBox.Show("urun eklendi"); } catch { MessageBox.Show("girdiğiniz telefone numarası: " + k.tel + " şeklinde olmamalı.535-5455464 şeklinde olmalıdır."); } }
private void button2_Click(object sender, EventArgs e) { kullanicilar k = new kullanicilar(); k.tel = textBoxTel.Text; //try //{ cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "update personelTablo set Ad='" + textBoxAd.Text + "',Soyad='" + textBoxSoyad.Text + "',tel='" + textBoxTel.Text + "',Il='" + textBoxIl.Text + "',Adres='" + textBoxAdres.Text + "',kullanıcıAd='" + textBoxKullaniciAdi.Text + "',kullaniciSifre='" + textBoxSifre.Text + "',Dept='" + comboBox1.Text + "';"; cmd.ExecuteNonQuery(); con.Close(); Goster(); MessageBox.Show("Personel güncellendi"); }