INSERT 语句中列的数目大于 VALUES 子句中指定的值的数目。VALUES 子句中值的数目必须与INSERT 语句中指定的列的数目匹配

发布时间 2023-06-01 09:25:24作者: wang王dd

出现这个问题首先就找到了insert语句,找到的insert语句

cmd.CommandText = "INSERT INTO Message_FHSQ ([contractid],[applytime],[service],[company],[project],[productname],[sub],[quantity],[unit],[amount],[fhck],[fhwl],[examine],[checkout],[readzt]) VALUES('" + htbh + "''" + sqsj + "','" + gdy + "','" + gsm + "','" + xmmc + "','" + cpmc + "','" + nr + "','" + sl + "','" + dw + "','" + je + "','一线成品仓','装车','未审核','未出库','未读')";

复制到navicat中执行,发现少了个,号

加上,号就好了

 正确代码:

cmd.CommandText = "INSERT INTO Message_FHSQ ([contractid],[applytime],[service],[company],[project],[productname],[sub],[quantity],[unit],[amount],[fhck],[fhwl],[examine],[checkout],[readzt]) VALUES('" + htbh + "','" + sqsj + "','" + gdy + "','" + gsm + "','" + xmmc + "','" + cpmc + "','" + nr + "','" + sl + "','" + dw + "','" + je + "','一线成品仓','装车','未审核','未出库','未读')";