private void lbox_varosok_SelectedIndexChanged(object sender, EventArgs e) { lbox_varoslatvanyossagai.Items.Clear(); Varos v = (Varos)lbox_varosok.SelectedItem; int id = getId(v); string sql = @" SELECT nev, leiras, ar, varos_id FROM latvanyossagok WHERE varos_id=@id "; var comm = this.conn.CreateCommand(); comm.CommandText = sql; comm.Parameters.AddWithValue("@id", id); using (var reader = comm.ExecuteReader()) { while (reader.Read()) { string nev = reader.GetString("nev"); string leairas = reader.GetString("leiras"); int ar = reader.GetInt32("ar"); int varosid = reader.GetInt32("varos_id"); Latvanyossag l = new Latvanyossag(nev, leairas, ar, varosid); lbox_varoslatvanyossagai.Items.Add(l); } } string tboxbanev = v.Nev; txtbx_varosneve.Text = Convert.ToString(tboxbanev); int tboxbalakossag = v.Lakossag; numupd_varoslakossag.Value = tboxbalakossag; }
private void btn_latvanyossaghozzaad_Click(object sender, EventArgs e) { if (txtbx_latvanyossagneve.Text.Length > 0 && rtbox_latvanyossagleiras.Text.Length > 0 && numupd_latvanyossagara.Value > 0 && lbox_varosok.SelectedIndex > -1) { string nev = txtbx_latvanyossagneve.Text; string leiras = rtbox_latvanyossagleiras.Text; int ar = Convert.ToInt32(numupd_latvanyossagara.Value); Varos v = (Varos)lbox_varosok.SelectedItem; int varosid = getId(v); var insertComm = conn.CreateCommand(); insertComm.CommandText = @" INSERT INTO latvanyossagok (nev,leiras,ar,varos_id) VALUES(@nev,@leiras,@ar,@varos_id) "; insertComm.Parameters.AddWithValue("@nev", nev); insertComm.Parameters.AddWithValue("@leiras", leiras); insertComm.Parameters.AddWithValue("@ar", ar); insertComm.Parameters.AddWithValue("@varos_id", varosid); insertComm.ExecuteNonQuery(); Latvanyossag l = new Latvanyossag(nev, leiras, ar, varosid); v.setLavanyossagok(l); } else { MessageBox.Show("Hiba! Nem megfelelő értékek", "Hiba!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }