急！！标准表达式中数据类型不匹配？！但是没发现什么问题啊？

[tangyy]

急！！标准表达式中数据类型不匹配？！但是没发现什么问题啊？


。。。。。。
jmgConn.Open();
InsertData = "insert into Sell(" + "[Number]" + "," + " [Date] " + "," + " Consignee " + "," + " Goods " + "," + " GoodsNumber " + "," + " Unit " + "," + " Quantity " + "," + " [Sum] " + "," + " Profit " + "," + " [Note] " + ") Values"
+ "('" + txtNumber.Value + "','" + txtDate.Value + "','" + txtConsignee.Value + "','" + txtGoods.Value + "','" + txtGoodsNumber.Value + "','" + txtUnit.Value + "','" + txtQuantity.Value + "','" + txtSum.Value + "','" + txtProfit.Value + "','" + txtNote.Value + "')";
jmgComm = new OleDbCommand(InsertData, jmgConn);
jmgComm.ExecuteNonQuery();
jmgConn.Close();
。。。。。。

[易企加_天马行空]

你把insertDAta的字符串copy下来，然后到查询分析器里执行下，看是哪个报错了。哪个字段的类型不匹配

这样写代码简直烂到家了，连自己都已经看不错错误了，哪怕用一个string.Format都比这样写强，肯定是字段类型不匹配导致的。

[shangxb]

把InsertData的内容复制到查询分析器里执行下看看吧
另外这么写自己看着也晕，而且不安全 建议还是用参数吧

[tangyy]

是使用 Access