private void btnSiradaki_Click(object sender, EventArgs e)
{
int rast = rand.Next(Kelimeler.Count);
SozlukKelime secili1 = Kelimeler[rast];
lblArapca.Text = secili1.Arapca;
lblTurkce.Text = secili1.Turkce;
}
public SozlukKelimeDuzeltme(SozlukKelime cell)
{
con.Open();
InitializeComponent();
cel = cell;
txtArapca.Text = cel.Arapca;
txtTurkce.Text = cel.Turkce;
}
private void dgvSozluk_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
SozlukKelime duzenlenecek = (SozlukKelime)dgvSozluk.SelectedRows[0].DataBoundItem;
SozlukKelimeDuzeltme frm = new SozlukKelimeDuzeltme(duzenlenecek);
frm.ShowDialog();
KelimeleriListele();
}
private void dgvSozluk_KeyDown(object sender, KeyEventArgs e)
{
if (dgvSozluk.SelectedRows.Count > 0 && e.KeyCode == Keys.Delete)
{
SozlukKelime silinecek = (SozlukKelime)dgvSozluk.SelectedRows[0].DataBoundItem;
string a = silinecek.Arapca;
Kelimeler.Remove(silinecek);
var cmd = new SqlCommand($"delete from Sozluk where Arapca ='{a}'", con);
cmd.ExecuteNonQuery();
}
KelimeleriListele();
}
private void KelimeleriCek()
{
var cmd = new SqlCommand("select * from Sozluk order by Arapca", con);
var dr = cmd.ExecuteReader();
Kelimeler = new BindingList <SozlukKelime>();
while (dr.Read())
{
Kelimeler.Add(new SozlukKelime {
Arapca = (string)dr["Arapca"], Turkce = (string)dr["Turkce"]
});
}
dr.Close();
int rast = rand.Next(Kelimeler.Count);
SozlukKelime secili1 = Kelimeler[rast];
lblArapca.Text = secili1.Arapca;
lblTurkce.Text = secili1.Turkce;
}
