private void latvanyossagHozzaadAdatbazishoz(string nev, string leiras, int ar, int varos_id) { string sql = @"INSERT INTO latvanyossagok (nev,leiras, ar,varos_id) VALUES ('" + nev + "','" + leiras + "'," + ar + ",'" + varos_id + "');"; var comm = conn.CreateCommand(); comm.CommandText = sql; using (var mentes = comm.ExecuteReader()); string value = varosokLstBx.SelectedItem.ToString(); string[] adatok = value.Split(' '); string nev1 = adatok[0]; if (GetID(nev1) == varos_id) { Latvanyossag l1 = new Latvanyossag(nev, leiras, ar, varos_id); latvanyossagokLstBx.Items.Add(l1.ToString()); } }
private void latvanyossagokKiiratas() { latvanyossagokLstBx.Items.Clear(); string value = varosokLstBx.SelectedItem.ToString(); string[] adatok = value.Split(' '); string nev = adatok[0]; string sql = @"SELECT nev, leiras, ar, varos_id FROM latvanyossagok WHERE varos_id =" + GetID(nev) + ";"; var comm = conn.CreateCommand(); comm.CommandText = sql; using (var mentes = comm.ExecuteReader()) { while (mentes.Read()) { Latvanyossag l1 = new Latvanyossag(mentes.GetString("nev"), mentes.GetString("leiras"), mentes.GetInt32("ar"), mentes.GetInt32("varos_id")); latvanyossagokLstBx.Items.Add(l1.ToString()); } } }