private void btnSil_Click(object sender, EventArgs e) { Uye silicenekuye = new Uye(); silicenekuye = (Uye)dataGridView1.CurrentRow.DataBoundItem; uye.uyesil(silicenekuye); Listele(); TxtUyeAd.Clear(); TxtUyeSoyad.Clear(); TxtUyeTC.Clear(); MTxtUyeTelNo.Clear(); CBUyeCinsiyet.Text = " "; }
private void btnGuncelle_Click(object sender, EventArgs e) { Uye eskiuye = new Uye(); eskiuye = (Uye)dataGridView1.CurrentRow.DataBoundItem; Uye yeniuye = new Uye(); yeniuye.TCNO = Convert.ToDouble(TxtUyeTC.Text); yeniuye.AD = TxtUyeAd.Text; yeniuye.SOYAD = TxtUyeSoyad.Text; yeniuye.TELEFON = MTxtUyeTelNo.Text; yeniuye.CINSIYET = CBUyeCinsiyet.Text; uye.uyeguncelle(eskiuye, yeniuye); Listele(); TxtUyeAd.Clear(); TxtUyeSoyad.Clear(); TxtUyeTC.Clear(); MTxtUyeTelNo.Clear(); CBUyeCinsiyet.Text = " "; }
public void uyesil(Uye K) { try { OleDbCommand cmd = new OleDbCommand("delete From UyeKayit Where TC='" + Convert.ToDouble(K.TCNO) + "'", con); cmd.CommandType = CommandType.Text; con.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }
public void uyeguncelle(Uye eskiuye, Uye yeniuye) { try { OleDbCommand cmd = new OleDbCommand("update UyeKayit SET Ad='" + yeniuye.AD.ToString() + "',Soyad='" + yeniuye.SOYAD.ToString() + "',Telefon='" + yeniuye.TELEFON.ToString() + "',Cinsiyet='" + yeniuye.CINSIYET.ToString() + "'Where TC= '" + eskiuye.TCNO.ToString() + "'", con); cmd.CommandType = CommandType.Text; con.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }
public void uyeekle(Uye K) { try { OleDbCommand cmd = new OleDbCommand("insert into UyeKayit (TC,Ad,Soyad,Telefon,Cinsiyet) Values ('" + Convert.ToDouble(K.TCNO) + "','" + K.AD.ToString() + "','" + K.SOYAD.ToString() + "','" + K.TELEFON.ToString() + "','" + K.CINSIYET.ToString() + "')", con); cmd.CommandType = CommandType.Text; con.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }
private void btnEkle_Click(object sender, EventArgs e) { if (TxtUyeTC.TextLength < 11) { MessageBox.Show("Tc Kimlik No 11 Haneden Küçük!!!"); } else { Uye yeniuye = new Uye(); yeniuye.TCNO = Convert.ToDouble(TxtUyeTC.Text); yeniuye.AD = TxtUyeAd.Text; yeniuye.SOYAD = TxtUyeSoyad.Text; yeniuye.TELEFON = MTxtUyeTelNo.Text; yeniuye.CINSIYET = CBUyeCinsiyet.Text; uye.uyeekle(yeniuye); Listele(); TxtUyeAd.Clear(); TxtUyeSoyad.Clear(); TxtUyeTC.Clear(); MTxtUyeTelNo.Clear(); CBUyeCinsiyet.Text = " "; } }