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();
运行这句就会出错,可是这些变量都是有值的。是数据类型的问题吗?
自己断看cmd.CommandText 的sql语句是什么就知道了,放到你数据库中执行
把CommandText 打印出来看看,哪里数据不对。应该是数据跟参数对应不上