private void Submit(string color, string vendor, string type) { try { var command = new OleDbCommand(); command.Connection = connection; command.CommandText = "INSERT INTO Color (COLOR, VENDOR, TYPE) VALUES('" + color + "', '" + vendor + "', '" + type + "')"; connection.Open(); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Color Inserted"); } catch (Exception ex) { MessageBox.Show("Error: " + ex.ToString()); connection.Close(); } if (null != parent) { parent.UpdateLists(); } else if (null != MaterialForm) { MaterialForm.UpdateLists(); } }
private void Submit(string type, string width, string height) { try { var command = new OleDbCommand(); command.Connection = connection; command.CommandText = "INSERT INTO Materials (MATERIAL_TYPE, DEFAULT_WIDTH, DEFAULT_HEIGHT) VALUES('" + type + "', '" + width + "', '" + height + "')"; connection.Open(); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Category Inserted"); } catch (Exception ex) { MessageBox.Show("Error: " + ex.ToString()); connection.Close(); } if (null != parent) { parent.UpdateLists(); } else if (null != MaterialForm) { MaterialForm.UpdateLists(); } }