protected void DeleteRow(int rowIndex) { GridViewRow row = grid.Rows[rowIndex]; var newValues = this.GetValues(row); connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";"); OleDbCommand cmd = new OleDbCommand(GetCommandString(Command.DELETE), connec); cmd.Parameters.AddWithValue(FIELDS[0], grid.DataKeys[row.RowIndex][FIELDS[0]]); int key = int.Parse(grid.DataKeys[row.RowIndex][FIELDS[0]].ToString()); try { int prodid = -1; string opname = ""; bool issueRoutingWarning = false; ClassF classA = null; if (TABLE_NAME.Equals("tbloper")) { try { prodid = int.Parse(GetDatabaseField("Prodfore", "OpID", key, "tblOper")); opname = GetDatabaseField("OpNam", "OpID", key, "tblOper"); try { classA = new ClassF(GetDirectory() + userDir); issueRoutingWarning = classA.repair_routings(key, opname, prodid); classA.Close(); } catch (Exception) { } } catch (Exception) { } } connec.Open(); try { int result = cmd.ExecuteNonQuery(); } catch (Exception excep) { Exception excepNew = new Exception("Error in executing delete query. Command string: " + cmd.CommandText + ". Exception message: " + excep.Message, excep); throw excepNew; } connec.Close(); grid.EditIndex = -1; this.SetData(); if (classA == null) { classA = new ClassF(GetDirectory() + userDir); } else { classA.Open(); } if (TABLE_NAME.Equals("tbllabor")) { classA.del_labor_res(key); classA.del_lab_ref(key); } else if (TABLE_NAME.Equals("tblequip")) { classA.del_eq_res(key); classA.del_eq_ref(key); } else if (TABLE_NAME.Equals("tblprodfore")) { classA.del_pt_res(key); } else if (TABLE_NAME.Equals("tbloper")) { // delete oper results ??? ask Greg classA.del_op_res(key); } classA.Close(); if (TABLE_NAME.Equals("tbloper")) { tableSync.UpdateOpNumbers(); } if (issueRoutingWarning) { Master.ShowInfoMessage("Routings for the operation were deleted. Please check out '" + opname + "' routing deleted does not leave a hole in the routings."); } } catch (Exception ex) { logFiles.ErrorLog(ex); try { connec.Close(); connec = null; } catch { } Master.ShowErrorMessage("An error has occured and the record could not get deleted."); } }