private void AdatBetoltes() { string sql = @" SELECT id,nev,uzlet from ajandek ORDER BY nev "; var comm = this.conn.CreateCommand(); comm.CommandText = sql; using (var reader = comm.ExecuteReader()) { while (reader.Read()) { int id = reader.GetInt32("id"); string nev = reader.GetString("nev"); string uzlet; try { uzlet = reader.GetString("uzlet"); } catch (SqlNullValueException ex) { uzlet = null; } var ajandek = new Ajandek(id, nev, uzlet); listBox1.Items.Add(ajandek); } } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { listBox1.Update(); var delet = conn.CreateCommand(); delet.CommandText = @"DELETE FROM `ajandek` WHERE `ajandek`.`id` = @id"; Ajandek p = (Ajandek)listBox1.SelectedItem; int id = p.Id; delet.Parameters.AddWithValue("@id", id); int erint = delet.ExecuteNonQuery(); listBox1.Items.RemoveAt(listBox1.SelectedIndex); }
private void button2_Click(object sender, EventArgs e) { var nev = textBoxnev.Text; var uzlet = textBoxuzlet.Text; var felvesz = conn.CreateCommand(); var id = listBox1.Items.Count + 1; var ajandek = new Ajandek(id, nev, uzlet); felvesz.CommandText = @"INSERT INTO ajandek (nev,uzlet) VALUES (@nev,@uzlet)"; felvesz.Parameters.AddWithValue("@nev", nev); felvesz.Parameters.AddWithValue("@uzlet", uzlet); int sorok = felvesz.ExecuteNonQuery(); listBox1.Items.Add(ajandek); listBox1.Update(); }