至少一个参数没有被指定值。

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\InspectionSystem.mdb");
conn.Open();
OleDbCommand InsertCommand = conn.CreateCommand();
string sql = "update temp as a,twzd as b set a.[加油站点]=b.[加油站点],a.[巡检点]=b.[巡检点],a.[巡检员编号]=b.[巡检员编号] where temp.[UID]=twzd.[UID] ";
OleDbCommand myCommand = new OleDbCommand(sql, conn);
myCommand.ExecuteNonQuery();
myCommand.ExecuteNonQuery();
conn.Close();

sql语句哪写的不对了？老是提示至少一个参数没有指定。。。

[解决办法]
更新多个表
update [表1] set [列名]=b.[列名]
FROM [表1] a,[表2] b
where a.[关联列]=b.[关联列]


或者使用inner join
[解决办法]
语法不正确


--正确做法

SQL code

    update a set a.[加油站点]=b.[加油站点],a.[巡检点]=b.[巡检点],a.[巡检员编号]=b.[巡检员编号] from temp as a inner join twzd as b on a.[UID]=b.[UID]      --其他条件则加 where a.XX=9 等