C# 异常：至少一个参数没有被指定值。

Question

cmd.CommandText = "insert into sheet1 (无线消息顺序,ID,无线消息号,无线消息变量,无线消息值,消息中的顺序,变量位数,变量字节数) values (" + currentseq + "," + (nextpacketID + i ).ToString() + "," + a + "," + "'D_LINK' " + "," + "'null' " + "," + (b + selectedvalue*6 + i + 1).ToString() + "," + 15 + "," + 2 + ")";
cmd.ExecuteNonQuery();
运行这句就会出错，可是这些变量都是有值的。是数据类型的问题吗？

Answer 1

自己断看cmd.CommandText 的sql语句是什么就知道了，放到你数据库中执行