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); } }