Dim Command As New OleDbCommand()
Command.Connection = Cnn
Command.CommandText = "Update TblCarObjects SET name = ?, Model = ?, Unit=?, Value = ?, BuyAmountUnit = ?, SumAmount = ?, SellAmountUnit = ?, DateBuy = ? where ObjCode like ? "
Command.Parameters.AddWithValue("name", TxtEditName.Text.ToString)
Command.Parameters.AddWithValue("Model", ComboEditModel.Text.ToString)
Command.Parameters.AddWithValue("Unit", TxtEditUnit.Text.ToString)
Command.Parameters.AddWithValue("Value", Val(TxtEditValue.Text.ToString))
Command.Parameters.AddWithValue("BuyAmountUnit", Val(TxtEditUnitAmount.Text.ToString))
Command.Parameters.AddWithValue("SumAmount", Val(TxtEditSumAmount.Text.ToString))
Command.Parameters.AddWithValue("SellAmountUnit", Val(TxtEditSellAmount.Text.ToString))
Command.Parameters.AddWithValue("DateBuy", TxtEditDate.Text.ToString)
Command.Parameters.AddWithValue("ObjCode", Val(TxtEditObjCode.Text.ToString))
Command.ExecuteNonQuery()
که توخط آخر خطای زیر رو میده:
Syntax error in UPDATE statement.