private void btnUpdate_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("DO YOU WANT UPDATE STOCK?", "STOCK UPDATION", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dialogResult == DialogResult.Yes) { if (tbEditAddStock.Value == 0 || tbEditFinalStock.Text == "" || tbEditItemName.Text == "" || tbEditItemCategory.Text == "" || tbEditItemStock.Text == "" || tbEditItemDescription.Text == "" || tbEditItemNumber.Text == "") { MessageBox.Show("FORM FIELD(S) CAN NOT BE LEFT EMPTY. PLEASE COMPLETE THE FORM TO EDIT DATA", "DATA UPDATE ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); tbEditAddStock.Focus(); } else { string InventoryNumber = tbEditItemNumber.Text; string InventoryName = tbEditItemName.Text; string InventoryDescription = tbEditItemDescription.Text; string InventoryCategory = tbEditItemCategory.Text; string ItemStock = tbEditFinalStock.Text; Admin Update = new Admin(); Update.UpdateStock(InventoryNumber, InventoryName, InventoryDescription, InventoryCategory, ItemStock); MessageBox.Show("STOCK UPDATED", "ITEM STOCK UPDATED", MessageBoxButtons.OK, MessageBoxIcon.Information); tbEditAddStock.Value = 0; tbEditItemNumber.Clear(); tbEditItemName.Clear(); tbEditItemDescription.Clear(); tbEditItemCategory.Clear(); tbEditFinalStock.Clear(); tbEditItemStock.Clear(); RefreshDG(); } } } catch (SqlException) { MessageBox.Show("MICROSOFT SQL SERVER DATABASE ERROR!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (InvalidOperationException) { MessageBox.Show("INVALID OPERATION!", "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "ERROR OCCURS", MessageBoxButtons.OK, MessageBoxIcon.Error); } }