private void FORMAdjustments_Modify_Load(object sender, System.EventArgs e) { //Set Edit OleDbCommand cmdAdjustBook = new OleDbCommand("UPDATE tblBooks SET Qty =@getQty, Barrowed =@getBarrowed WHERE BookNo LIKE '" + sBookID + "' ", clsConnections.CN); FillFields(); cmdAdjustBook.Parameters.Add("@getQty", OleDbType.Double); cmdAdjustBook.Parameters.Add("@getBarrowed", OleDbType.Double); publicBooksList = this; }
private void bttnAdjust_Click(object sender, System.EventArgs e) { if (lvBooks.Items.Count > 0) { try { FORMAdjustments_Modify.sBookID = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[0].Text; FORMAdjustments_Modify.sISBN = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[1].Text; FORMAdjustments_Modify.sBookTitle = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[2].Text; FORMAdjustments_Modify.sQuantity = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[3].Text; FORMAdjustments_Modify.sBarrowed = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[4].Text; FORMAdjustments_Modify.sAvailable = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[5].Text; FORMAdjustments_Modify sForm = new FORMAdjustments_Modify(); sForm.ShowDialog(); } catch (ArgumentOutOfRangeException aooreE) { MessageBox.Show("" + aooreE.Message); } catch (NullReferenceException nreE) {} } else { MessageBox.Show("No record to edit.", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }