public void latvanyossagListaz() { listLatvanyossag.Items.Clear(); var command = conn.CreateCommand(); var varosok = (varosok)listVaros.SelectedItem; if (varosok != null) { command.CommandText = @"SELECT id,nev,leiras,ar,varos_id FROM latvanyossagok WHERE varos_id = " + varosok.Id; using (var reader = command.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt32("id"); var nev = reader.GetString("nev"); var leiras = reader.GetString("leiras"); var ar = reader.GetInt32("ar"); var varos_id = reader.GetInt32("varos_id"); var latvanyossag = new latvanyossagok(id, nev, leiras, ar, varos_id); listLatvanyossag.Items.Add(latvanyossag); } } } }
void kivalaszthatoVarosokListazasa(int varosid) { listBoxLatvanyossagok.Items.Clear(); var cmd = conn.CreateCommand(); cmd.CommandText = "SELECT id, nev, leiras, ar, varos_id FROM latvanyossagok LEFT JOIN varosok ON latvanyossagok.varos_id = varosok.id WHERE varos_id = @varos_id"; cmd.Parameters.AddWithValue("@varos_id", varosid); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt32("id"); var nev = reader.GetString("nev"); var leiras = reader.GetString("leiras"); var ar = reader.GetInt32("ar"); var varos_id = reader.GetInt32("varos_id"); var varoska = new latvanyossagok(id, nev, leiras, ar, varos_id); listBoxLatvanyossagok.Items.Add(varoska); } } }
private void latvanyossagListaz() { latvanyossagLista.Items.Clear(); var cmd = conn.CreateCommand(); cmd.CommandText = @"SELECT id,nev,leiras,ar,varos_id FROM latvanyossagok WHERE varos_id=@varos_id ORDER BY nev"; var varos = (Varosok)varosLista.SelectedItem; cmd.Parameters.AddWithValue("@varos_id", varos.Id); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt32("id"); var nev = reader.GetString("nev"); var leiras = reader.GetString("leiras"); var ar = reader.GetInt32("ar"); var varos_id = reader.GetInt32("varos_id"); var latvanyossagok = new latvanyossagok(id, nev, leiras, ar, varos_id); latvanyossagLista.Items.Add(latvanyossagok); } } }