C# Access 标准表达式中数据类型不匹配

2025-02-27 20:58:42

推荐回答（2个）

回答1：

你的问题，就是sql里把数量去加字符串，当然出错了

set [数量] = [数量] + '" + Convert.ToDouble(information[4].ToString()) + "'
把+后面的单引号去掉就ok了，变成：
set [数量] = [数量] + " + Convert.ToDouble(information[4].ToString()) + "

回答2：

update [inventory] set [数量] = [数量] + " + Convert.ToDouble(information[4].ToString()) + "WHERE [名称] = '" + information[0].ToString() + "' AND [规格] = '" + information[1].ToString() + "' AND [单位] = '" + information[2].ToString() + "' AND [单价] = "+ Convert.ToDouble(information[3].ToString()) + ";"
insert into [inventory] (名称,规格,单位,单价,数量) values ('" + information[0].ToString() + "','" + information[1].ToString() + "','" + information[2].ToString() + "'," + Convert.ToDouble(information[3].ToString()) + ","+ Convert.ToDouble(information[4].ToString())+");"