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