private void cefreListaz(int f)
{
listCefre.Items.Clear();
var cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT id,gyumolcs,alkohol,egysegar,fozde_id FROM cefre WHERE fozde_id = @fozde_id ORDER BY id";
var fozde = (Fozde)listFozde.SelectedItem;
cmd.Parameters.AddWithValue("@fozde_id", fozde.Id);
cmd.ExecuteNonQuery();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt32("id");
var gyumolcs = reader.GetString("gyumolcs");
var alkohol = reader.GetInt32("alkohol");
var egysegar = reader.GetInt32("egysegar");
var fozde_id = reader.GetInt32("fozde_id");
var cefre = new Cefre(id, gyumolcs, alkohol, egysegar, fozde_id);
listCefre.Items.Add(cefre);
}
}
}
private void listCefre_SelectedIndexChanged(object sender, EventArgs e)
{
var cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT id,gyumolcs,alkohol,egysegar, fozde_id FROM cefre WHERE fozde_id = @fozde_id ORDER BY id";
var fozde = (Fozde)listFozde.SelectedItem;
cmd.Parameters.AddWithValue("@fozde_id", fozde.Id);
cmd.ExecuteNonQuery();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt32("id");
var gyumolcs = reader.GetString("gyumolcs");
var alkohol = reader.GetInt32("alkohol");
var egysegar = reader.GetInt32("egysegar");
var fozde_id = reader.GetInt32("fozde_id");
var cefre = new Cefre(id, gyumolcs, alkohol, egysegar, fozde_id);
gyumolcstext.Text = gyumolcs;
alkoholtext.Text = alkohol.ToString();
egysegartext.Text = egysegar.ToString();
fozde_idtext.Text = fozde_id.ToString();
}
}
idszam.Text = listCefre.SelectedIndex.ToString();
}