Hi,
You are using named parameters which is not possible with oledbcommand. You need to use ? char for parameters, and when you add parameters in command parameters collection you need to add them in proper order like you have parameters in your query...
Example:
string updateSql = "UPDATE RateCenters SET RateCenterName = ?, Province=
?, QuantityThreshold = ? WHERE RateCenterID= ?";
OleDbParameter p1 = new OleDbParameter();
OleDbParameter p2 = new OleDbParameter();
OleDbParameter p3 = new OleDbParameter();
OleDbParameter p4 = new OleDbParameter();
p1.Value = "RateCenterName ";
p2.Value = "Province";
p3.Value = "QuantityThreshold ";
p2.Value = "RateCenterID";
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
While adding parameters you need to add them in order like they are in command...
The code maybe have errors and its provided just to show what I mean...