帮我看看数据库更新的问题，急！！！在线等~~

[IT_Fish]

dim cmd as SqlCommand = new SqlCommand(sql,Conn)
cmd.ExecuteNonQuery()

sql = "UPDATE ERS SET (Vendor_Qty=850,Vendor_price=0.7038,Vendor_Amount=598.23) WHERE (Vendor='260133' AND Week='W0438' AND Item ='4' AND Reference_Doc='5000706360')"

请问这哪出错了？

出错提示：
第 1 行: '(' 附近有语法错误
行 269： sql = ………………………………（上面所示）
行 270： dim cmd as SqlCommand = new SqlCommand(sql,Conn)
行 271： cmd.ExecuteNonQuery()
行 272： label1.text = "Command Performed Successfully !"

[surf88]

sql = "UPDATE ERS SET Vendor_Qty=850,Vendor_price=0.7038,Vendor_Amount=598.23 WHERE (Vendor='260133' AND Week='W0438' AND Item ='4' AND Reference_Doc='5000706360')"

set 后面不要（）的吧

[IT_Fish]

没人能帮我么？

[surf88]

你把set 后面的（）去掉看看啊

[zhanglizhao]

去掉（）就可以了！