private void Torles_Click(object sender, EventArgs e)
{
try
{
string kepesseg_neve = KepessegekLista.GetItemText(KepessegekLista.SelectedItem);
if (kepesseg_neve.Length > 0)
{
string delete = "DELETE FROM kepessegek WHERE nev = '" + kepesseg_neve + "'";
var delete_command = conn.CreateCommand();
delete_command.CommandText = delete;
delete_command.ExecuteNonQuery();
KepessegekListaja();
KepessegText.Text = "";
}
else
{
MessageBox.Show("Nincs kiválasztva képesség!");
}
}
catch (MySqlException ex)
{
throw;
}
}
private void modositas_Click(object sender, EventArgs e)
{
try
{
string kepesseg_nev = KepessegekLista.GetItemText(KepessegekLista.SelectedItem);
if (kepesseg_nev.Length > 0)
{
string tartalom = KepessegText.Text;
var Update = conn.CreateCommand();
Update.CommandText = "UPDATE kepessegek SET leiras = @leiras WHERE nev = @nev";
Update.Parameters.AddWithValue("@leiras", tartalom);
Update.Parameters.AddWithValue("@nev", kepesseg_nev);
int erintettSorok = Update.ExecuteNonQuery();
}
else
{
MessageBox.Show("Nincs kiválasztva képesség!");
}
}
catch (Exception)
{
throw;
}
}
private void LeirasMegjelenit()
{
KepessegText.Text = "";
try
{
string kepesseg_nev = KepessegekLista.GetItemText(KepessegekLista.SelectedItem);
MySqlDataReader reader = null;
string select = @"SELECT leiras
FROM kepessegek
WHERE nev = '" + kepesseg_nev + "'";
MySqlCommand command = new MySqlCommand(select, conn);
reader = command.ExecuteReader();
while (reader.Read())
{
string leiras = (string)reader["leiras"];
KepessegText.Text = leiras;
}
reader.Close();
}
catch (Exception)
{
throw;
}
}
