private void lBVarosLista_SelectedIndexChanged(object sender, EventArgs e) { if (lBVarosLista.SelectedIndex > -1) { lBLatvanyosagLista.Items.Clear(); gBVarosModosit.Visible = true; bVarosTorol.Visible = true; Varos varos = (Varos)lBVarosLista.SelectedItem; string sql = @" SELECT id, nev, leiras, ar, varos_id FROM latvanyossagok WHERE varos_id = @varos_id "; var comm = this.conn.CreateCommand(); comm.CommandText = sql; comm.Parameters.AddWithValue("@varos_id", varos.getId()); using (var reader = comm.ExecuteReader()) { while (reader.Read()) { int id = reader.GetInt32("id"); string nev = reader.GetString("nev"); string leiras = reader.GetString("leiras"); int ar = reader.GetInt32("ar"); int varosId = reader.GetInt32("varos_id"); Latvanyossag latvanyosag = new Latvanyossag(id, nev, leiras, ar, varosId); lBLatvanyosagLista.Items.Add(latvanyosag); } } } }
private void bVarosModosit_Click(object sender, EventArgs e) { if (lBVarosLista.SelectedIndex > -1) { string sql = @" UPDATE `varosok` SET `nev`= @nev, `lakossag`= @lakossag WHERE id`= @id, "; Varos varos = (Varos)lBVarosLista.SelectedItem; var comm = this.conn.CreateCommand(); comm.CommandText = sql; comm.Parameters.AddWithValue("@id", varos.getId()); comm.Parameters.AddWithValue("@nev", tBVarosNevModosit.Text); comm.Parameters.AddWithValue("@lakossag", nUADVarosLakosagaModosit); comm.ExecuteNonQuery(); } else { MessageBox.Show("nem választotad ki mit akarsz modositani."); } lBVarosLista.SelectedIndex = -1; gBVarosModosit.Visible = false; bVarosTorol.Visible = false; }