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