private void updateButton_Click(object sender, EventArgs e) { string q1 = "SELECT COUNT(*) FROM EQUIPMENT WHERE EQUIPMENT.EQUIPMENT_NAME = '" + EquipCombobox.Text + "' AND EQUIPMENT.STATUS = '1' "; string q2 = "SELECT COUNT(*) FROM INVENTORY WHERE INVENTORY.TERM_ID = '" + TermIDTextbox.Text + "' AND INVENTORY.STATUS = '1' "; string query = "SELECT TERM_ID FROM INVENTORY WHERE INVENTORY_ID = '" + IDTextbox.Text + "' "; string queryCheck1 = "SELECT PROJECT_NAME FROM PROJECT JOIN INVENTORY ON INVENTORY.PROJECT_ID = PROJECT.PROJECT_ID " + "WHERE INVENTORY.INVENTORY_ID = '" + IDTextbox.Text + "' "; string queryCheck2 = "SELECT EQUIPMENT_NAME FROM EQUIPMENT JOIN INVENTORY ON INVENTORY.EQUIPMENT_ID = EQUIPMENT.EQUIPMENT_ID " + "WHERE INVENTORY.INVENTORY_ID = '" + IDTextbox.Text + "' "; string queryCheck3 = "SELECT TERM_ID FROM INVENTORY WHERE INVENTORY.INVENTORY_ID = '" + IDTextbox.Text + "' "; List <string> editList = new List <string>(); //EditChecking(q1); //EditTermIDCheck(q2); if (DataTableSQLQuery(q1).Rows[0][0].ToString() == "0") { MessageBox.Show("Not a valid value"); } else { eqCheck = true; } if ((DataTableSQLQuery(q2).Rows[0][0].ToString() == "1") && (ScalarSQLQuery(query, con) != TermIDTextbox.Text)) { MessageBox.Show("TERM ID already exists."); } else { tmCheck = true; } if ((eqCheck == true) && (tmCheck == true)) { eqCheck = false; tmCheck = false; UpdateList(queryCheck1, IDTextbox.Text, ProjectCombobox.Text, editList); UpdateList(queryCheck2, IDTextbox.Text, EquipCombobox.Text, editList); UpdateList(queryCheck3, IDTextbox.Text, TermIDTextbox.Text, editList); for (int i = 0; i < editList.Count; i++) { Console.WriteLine(editList[i]); History.HistoryInventoryUpdate(editList[i]); } Inventory.UpdateButton(EquipCombobox, ProjectCombobox, TermIDTextbox, IDTextbox, con); } InventoryDataGrid.DataSource = null; Inventory.DisplayInventory(InventoryDataGrid, con); checkBox1.Checked = false; }