asked on
Dim sqlupdate As String
sqlupdate = "UPDATE BMW_Maintenance SET Oil_Change=@Oil_Change, Cabin_Filter=@Cabin_Filter, " & _
"Air_Filter=@Air_Filter, Engine_Coolant=@Engine_Coolant, Differential_Oil=@Differential_Oil, " & _
"Spark_Plugs=@Spark_Plugs, Trans_Fluid_and_Filter=@Trans_Fluid_and_Filter, Engine_Drive_Belts=@Engine_Drive_Belts, " & _
"O2_Sensors=@O2_Sensors, Water_and_Fuel_Hoses=@Water_and_Fuel_Hoses, Fuel_Filter=@Fuel_Filter, " & _
"Tires=@Tires, Wheel_Alignment=@Wheel_Alignment, Notes=@Notes, Battery=@Battery, " & _
"Brake_Fluid=@Brake_Fluid, Power_Steering=@Power_Steering WHERE ID=@id"
Dim cmd As New OleDbCommand(sqlupdate, con1)
' This assigns the values for our columns in the DataBase.
' To ensure the correct values are written to the correct column
cmd.Parameters.AddWithValue("@Oil_Change", tbOil.Text)
cmd.Parameters.AddWithValue("@Cabin_Filter", tbCabin.Text)
cmd.Parameters.AddWithValue("@Brake_Fluid", tbBF.Text)
cmd.Parameters.AddWithValue("@Power_Steering", tbPS.Text)
cmd.Parameters.AddWithValue("@Air_Filter", tbAF.Text)
cmd.Parameters.AddWithValue("@Engine_Coolant", tbCoolant.Text)
cmd.Parameters.AddWithValue("@Differential_Oil", tbdiff.Text)
cmd.Parameters.AddWithValue("@Spark_Plugs", tbspark.Text)
cmd.Parameters.AddWithValue("@Trans_Fluid_and_Filter", tbtrans.Text)
cmd.Parameters.AddWithValue("@Engine_Drive_Belts", tbbelts.Text)
cmd.Parameters.AddWithValue("@O2_Sensors", tbO2.Text)
cmd.Parameters.AddWithValue("@Water_and_Fuel_Hoses", tbhoses.Text)
cmd.Parameters.AddWithValue("@Fuel_Filter", tbFF.Text)
cmd.Parameters.AddWithValue("@Tires", tbtires.Text)
cmd.Parameters.AddWithValue("@Wheel_Alignment", tbwheel.Text)
cmd.Parameters.AddWithValue("@Notes", tbnotes.Text)
cmd.Parameters.AddWithValue("@Battery", tbbat.Text)
cmd.Parameters.AddWithValue("@ID", Convert.ToInt32(tbid.Text))
con1.Open()
cmd.ExecuteNonQuery()
con1.Close()