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();
}
