cmd.CommandText 二维数组向数据库插入数据,提示有‘11’附近有语法错误
[code=VB.NET][/code]cmd.CommandText = "insert into test_主表 values(" & mx_dt(i, 0) & "," & mx_dt(i, 1) & "," & mx_dt(i, 2) & "," & mx_dt(i, 3) & "," & mx_dt(i, 4) & "," & mx_dt(i, 5) & "," & mx_dt(i, 6) & ")"
[解决办法]
改成类似这样
cmd.CommandText = "insert into test_主表 values('" & mx_dt(i, 0) & "','" & mx_dt(i, 1) & "')"//后面参数也一样