public void UpdateViewTrening()
{
try
{
dataAdapterViewTrening =
new OleDbDataAdapter(@"SELECT Вид_тренировки.* FROM Вид_тренировки;", connection);
dataTableViewTrening = new DataTable();
dataAdapterViewTrening.Fill(dataTableViewTrening);
ViewmetroGrid1.DataSource = dataTableViewTrening;
ViewmetroGrid1.Columns[0].Visible = false;
ViewmetroGrid1.Sort(ViewmetroGrid1.Columns[1], ListSortDirection.Ascending);
ViewmetroGrid1.Select();
ViewmetroGrid1.AllowUserToAddRows = false;
FocusMe();
}
catch (Exception exception)
{
MetroMessageBox.Show(this, exception.Message, TitleException, MessageBoxButtons.OK,
MessageBoxIcon.Error);
HelperLog.Write(exception.ToString());
}
}
private void metroButton3_Click(object sender, EventArgs e)
{
if (DialogResult.Yes == MetroMessageBox.Show(this, "\nУдалить запись?", "Удалить?",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
{
try
{
if (ViewmetroGrid1.RowCount == 0)
{
MetroMessageBox.Show(this, "Записей больше нет", "Таблица пуста", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
connection.Open();
var idViewTrening = Convert.ToInt32(ViewmetroGrid1.CurrentRow.Cells[0].Value);
var queryDeleteViewTtrening = new OleDbCommand(@"DELETE FROM Вид_тренировки
WHERE идвидтренировка=" + idViewTrening + "",
connection);
queryDeleteViewTtrening.ExecuteNonQuery();
ViewmetroGrid1.Sort(ViewmetroGrid1.Columns[1], ListSortDirection.Ascending);
UpdateViewTrening();
}
}
catch (Exception exception)
{
MetroMessageBox.Show(this, exception.Message, TitleException, MessageBoxButtons.OK,
MessageBoxIcon.Error);
HelperLog.Write(exception.ToString());
}
finally
{
connection.Close();
FocusMe();
}
}
}
