public static Kelime[] progressSorulacakKelimeleriCek() { int[] progressIdler = DB_Main.prSorulacakIdleriCek(); int kelimeSayisi = DB_Main.prSorulacakKelimeSayisiBelirle(); Kelime[] kelimeler = new Kelime[kelimeSayisi]; for (int i = 0; i < kelimeSayisi; i++) { kelimeler[i] = kelimeCek(progressIdler[i]); } return(kelimeler); }
public static bool kelimeMevcutMu(Kelime kelime) { bool mevcutMu = false; DB_Main.dbBaglan(); cmd.Connection = DB_Main.con; cmd.CommandText = "SELECT * FROM kelimeler " + "WHERE tr = '" + kelime.tr + "'"; int Count = Convert.ToInt32(cmd.ExecuteScalar()); if (Count != 0) { mevcutMu = true; } DB_Main.dbBaglantiKes(); return(mevcutMu); }
public static Kelime kelimeCek(int kelimeId) { DB_Main.dbBaglan(); cmd.Connection = DB_Main.con; cmd.CommandText = "SELECT * FROM kelimeler WHERE id = " + kelimeId; reader = cmd.ExecuteReader(); Kelime kelime = new Kelime(); while (reader.Read()) { kelime.id = Convert.ToInt32(reader["id"]); kelime.tr = reader["tr"].ToString(); kelime.ing = reader["ing"].ToString(); kelime.tur = reader["tur"].ToString(); kelime.trCumle = reader["trCumle"].ToString(); kelime.ingCumle = reader["ingCumle"].ToString(); } reader.Close(); DB_Main.dbBaglantiKes(); return(kelime); }
private void AnaMenu_Load(object sender, EventArgs e) { Kelime k = DB_Kelime.kelimeCek(1); MessageBox.Show(k.ing); }
private void soruyuGoster(Kelime kelime) { lblTestIng.Text = kelime.ing; lblTestIngCumle.Text = kelime.ingCumle; }