private void updateButt_Click(object sender, EventArgs e) { try { //setting the database OleDbConnection modelDB = new OleDbConnection (@"provider=Microsoft.ACE.OLEDB.12.0; data source =" + dbLocation); //opening the database modelDB.Open(); //setting Query OleDbCommand editModels = new OleDbCommand ("UPDATE Models SET Manafacturer = '" + manafEdit.Text + "' ,ChassisCode = '" + chassisEdit.Text + "' ,Make = '" + makeEdit.Text + "' ,Model = '" + modelEdit.Text + "' ,Variant = '" + variantEdit.Text + "' ,Qty = " + Convert.ToInt32(qtyEdit.Text) + ",Description = '" + descrEdit.Text + "' WHERE ID = " + id + ";", modelDB); int result = editModels.ExecuteNonQuery(); if (result > 0) { } else { MessageBox.Show("Failed"); } //closing the database modelDB.Close(); //disposing of the connection modelDB.Dispose(); //refreshing the database myParent.dBRefresh(); //closing the form this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void insertButt_Click(object sender, EventArgs e) { // Setting the database OleDbConnection modelDB = new OleDbConnection(@"provider=Microsoft.ACE.OLEDB.12.0; data source = " + dbaseLoc); //opening up the database modelDB.Open(); //setting the query to insert the data OleDbCommand insertEntry = new OleDbCommand("INSERT into Models(Manafacturer,ChassisCode,Make,Model,Variant,Qty,Description) VALUES('" + manafInsert.Text + "','" + chassisInsert.Text + "','" + makeInsert.Text + "','" + modelInsert.Text + "','" + variantInsert.Text + "'," + Convert.ToInt32(qtyInsert.Text) + ",'" + descrInsert.Text + "');", modelDB); //sending the query int result = insertEntry.ExecuteNonQuery(); if (result > 0) { } else { MessageBox.Show("Failure: Entry Not Added"); } //closing the database modelDB.Close(); //disposing of the connection modelDB.Dispose(); //refreshing the Main Database myParent.dBRefresh(); //closing the form this.Close(); }