unable to update a table on a access database [modified]

[mocasu]

hi all, Any ideas as to why the database is not being updated will be greatly appreciated! It is driving me mad...and I just can't see what i am doing wrong :confused: string dId = "Golden"; string dCharge = "150"; OleDbConnection connectDb = new OleDbConnection(db); connectDb.Open(); OleDbCommand update = new OleDbCommand("UPDATE ShippingCharges SET Charge = ? WHERE ShippingID = ?", connectDb); update.Parameters.Add("@ShippingID", OleDbType.Char).Value = dId; update.Parameters.Add("@Charge", OleDbType.Integer).Value = dCharge; update.ExecuteNonQuery(); connectDb.Close(); -- modified at 12:18 Saturday 1st December, 2007

[Lost User]

mocasu wrote:

update.Parameters.Add("@ShippingID", OleDbType.Char).Value = dId; update.Parameters.Add("@Charge", OleDbType.Integer).Value = dCharge;

shouldn't the update command be "Update ShippingCharges set Charge = @Charge where ShippingID = @ShippingID" if you call your updateParameters like that?

[mocasu]

Thanks...but either way the database is not being updated :(

[PIEBALDconsult]

The parameters need to be added in the correct order. Even when named.

[mocasu]

Thanks a lot! :) As you said, I had just switched the add parameter code and ...voilA!

[PIEBALDconsult]

Glad to be of service.