//Редактирование строки в БД
public void editRoom()
{
string[] room = EditRoom.Edit();
string query = "UPDATE `номер` SET `Состояние` = '" + room[1] + "',`Цена за ночь` = '" + room[2] + "',`Оценка номера` = '" + room[3] + "',`id_набора особенностей` = '" + room[4] + "' WHERE(`Номер` = '" + room[0] + "')";
MySqlCommand command = new MySqlCommand(query, connection);
command.CommandTimeout = 60;
MySqlDataReader reader;
try
{
connection.Open();
reader = command.ExecuteReader();
// Succesfully deleted
connection.Close();
}
catch (Exception ex)
{
// Ops, maybe the id doesn't exists ?
MessageBox.Show(ex.Message);
}
}
