void IstatistikGetir()
{
SqlBaglantisi sb = new SqlBaglantisi();
SqlCommand komut = new SqlCommand("SELECT Word_Dogru,Word_Yanlis FROM Tbl_Istatistik ", sb.Baglanti());
komut.ExecuteNonQuery();
SqlDataReader drr = komut.ExecuteReader();
if (drr.Read())
{
lblDogru.Text = drr["Word_Dogru"].ToString();
lblYanlis.Text = drr["Word_Yanlis"].ToString();
int dogru = Convert.ToInt32(drr["Word_Dogru"]);
int yanlis = Convert.ToInt32(drr["Word_Yanlis"]);
lblToplam.Text = (dogru + yanlis).ToString();
}
sb.Baglanti().Dispose();
sb.Baglanti().Close();
}
private void BtnEkle_Click(object sender, EventArgs e)
{
try
{
SqlBaglantisi sb = new SqlBaglantisi();
string date = DateTime.Now.ToShortDateString();
SqlCommand sc = new SqlCommand("INSERT INTO Tbl_Word (Word_Ingilizce,Word_Turkce,Word_Level,Word_Date) values (@p1,@p2,@p3,@p4)", sb.Baglanti());
sc.Parameters.AddWithValue("@p1", TxtIngilizce.Text);
sc.Parameters.AddWithValue("@p2", TxtTurkce.Text);
sc.Parameters.AddWithValue("@p3", '0');
sc.Parameters.AddWithValue("@p4", Convert.ToDateTime(date));
sc.ExecuteNonQuery();
sb.Baglanti().Dispose();
sb.Baglanti().Close();
MessageBox.Show("Kelime Sisteme Başarıyla Eklendi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtIngilizce.Text = "";
TxtTurkce.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
