private void varosTorles_Click(object sender, EventArgs e) { if (listBoxfelvettVarosok.SelectedIndex == -1) { MessageBox.Show("Nincs város kiválasztva!"); return; } listBoxLatvanyossagok.Items.Clear(); var cmd = conn.CreateCommand(); cmd.CommandText = "DELETE FROM varosok where id = @id and (SELECT varos_id FROM latvanyossagok where varos_id = varosok.id)"; var varos = (varosok)listBoxfelvettVarosok.SelectedItem; cmd.Parameters.AddWithValue("@id", varos.Id); var cmd2 = conn.CreateCommand(); cmd2.CommandText = "SELECT id, nev, lakossag FROM varosok ORDER BY nev"; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt32("id"); var nev = reader.GetString("nev"); var lakossag = reader.GetInt32("lakossag"); var varoska = new varosok(id, nev, lakossag); listBoxfelvettVarosok.Items.Add(varoska); listBoxLatvanyossagok.Items.Add(varoska); } //if (varos.Id == ) } cmd.ExecuteNonQuery(); varosokKilistazasa(); }
void varosokKilistazasa() { listBoxfelvettVarosok.Items.Clear(); var cmd = conn.CreateCommand(); cmd.CommandText = "SELECT id, nev, lakossag FROM varosok ORDER BY nev"; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt32("id"); var nev = reader.GetString("nev"); var lakossag = reader.GetInt32("lakossag"); var varoska = new varosok(id, nev, lakossag); listBoxfelvettVarosok.Items.Add(varoska); listBoxLatvanyossagok.Items.Add(varoska); } } }
void varosListaz() { listVaros.Items.Clear(); var command = conn.CreateCommand(); if (listVaros.SelectedIndex == 0) { } command.CommandText = @"SELECT id,nev,lakossag FROM varosok ORDER BY nev"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { var id = reader.GetInt32("id"); var nev = reader.GetString("nev"); var lakossag = reader.GetInt32("lakossag"); var varos = new varosok(id, nev, lakossag); listVaros.Items.Add(varos); } } }