1-) C# - 83. Delete ile Silme
using System;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Personel_kayit
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection baglanti = new SqlConnection("Data Source=DESKTOP-8553EL0;Initial Catalog=PersonelVeriTabani;Integrated Security=True");//kopyalanmış databaseyi yapıştırıyoruz.
void temizle()
{
Txtid.Text = "";
TxtAd.Text = "";
TxtSoyad.Text = "";
TxtMeslek.Text = "";
MskMaas.Text = "";
CmbSehir.Text = "";
radioButton1.Checked = false;
radioButton2.Checked = true;
TxtAd.Focus();
}
private void label3_Click(object sender, EventArgs e)
{
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
this.tbl_PersonelTableAdapter.Fill(this.personelVeriTabaniDataSet.Tbl_Personel);
}
private void BtnListele_Click(object sender, EventArgs e)
{
this.tbl_PersonelTableAdapter.Fill(this.personelVeriTabaniDataSet.Tbl_Personel);
}
private void BtnKaydet_Click(object sender, EventArgs e)
{
baglanti.Open();
SqlCommand komut = new SqlCommand("insert into Tbl_Personel (PerAd,PerSoyad,PerSehir,PerMaas,PerMeslek,PerDurum) values(@p1,@p2,@p3,@p4,@p5,@p6)", baglanti);
komut.Parameters.AddWithValue("@p1", TxtAd.Text);
komut.Parameters.AddWithValue("@p2", TxtSoyad.Text);
komut.Parameters.AddWithValue("@p3", CmbSehir.Text);
komut.Parameters.AddWithValue("@p4", MskMaas.Text);
komut.Parameters.AddWithValue("@p5", TxtMeslek.Text);
komut.Parameters.AddWithValue("@p6", label8.Text);
komut.ExecuteNonQuery();
baglanti.Close();
MessageBox.Show("Personel Eklendi");
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
label8.Text = "True";
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
if (radioButton2.Checked == true)
{
label8.Text = "False";
}
}
private void BtnTemizle_Click(object sender, EventArgs e)
{
temizle();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int secilen = dataGridView1.SelectedCells[0].RowIndex;
Txtid.Text = dataGridView1.Rows[secilen].Cells[0].Value.ToString();
TxtAd.Text = dataGridView1.Rows[secilen].Cells[1].Value.ToString();
TxtSoyad.Text = dataGridView1.Rows[secilen].Cells[2].Value.ToString();
CmbSehir.Text = dataGridView1.Rows[secilen].Cells[3].Value.ToString();
MskMaas.Text = dataGridView1.Rows[secilen].Cells[4].Value.ToString();
label8.Text = dataGridView1.Rows[secilen].Cells[5].Value.ToString();
TxtMeslek.Text = dataGridView1.Rows[secilen].Cells[6].Value.ToString();
}
private void label8_TextChanged(object sender, EventArgs e)
{
if (label8.Text == "True")
{
radioButton1.Checked = true;
}
if (label8.Text == "False")
{
radioButton2.Checked = true;
}
}
private void BtnSil_Click(object sender, EventArgs e)
{
baglanti.Open();
SqlCommand komutsil = new SqlCommand("Delete From Tbl_Personel Where Perid=@k1", baglanti);
komutsil.Parameters.AddWithValue("@k1", Txtid.Text);
komutsil.ExecuteNonQuery();
baglanti.Close();
MessageBox.Show("Kayıt Silindi");
}
private void BtnGuncelle_Click(object sender, EventArgs e)
{
baglanti.Open();
baglanti.Close();
}
}
}