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();
}
