private void UpdateBtn_Click(object sender, EventArgs e) { int selectedRowIndex = 0; if (table.SelectedCells.Count > 0) { Software.Model.Data Data = new Software.Model.Data(); selectedRowIndex = table.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = table.Rows[selectedRowIndex]; Data.Id = Convert.ToInt32(Convert.ToString(selectedRow.Cells["Id"].Value)); Data.Data_Name = nameBox.Text; Data.Data_Value = Convert.ToInt32(Convert.ToString(selectedRow.Cells["Data_Value"].Value)); Software.Database.SQL.DataDB.UpdateData(Data); MetroFramework.MetroMessageBox.Show(this, "Your data has been updated successfully.", "Successfully Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MetroFramework.MetroMessageBox.Show(this, "You must select a row to update its value!", "Invalid Selection"); } DoRefresh(); table.CurrentCell = table.Rows[selectedRowIndex].Cells[0]; table.Rows[selectedRowIndex].Selected = true; }
private void createBtn_Click(object sender, EventArgs e) { Software.Model.Data Data = new Software.Model.Data(); Data.Data_Name = nameBox.Text; Data.Data_Value = Convert.ToInt32(datavalBox.Text); Software.Database.SQL.DataDB.InsertData(Data); MetroFramework.MetroMessageBox.Show(this, "Data has been inserted!", "Successfully Completed", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); }