VB.NET 向Access数据库中添加数据的问题(急急！！)？
下面是我的代码
Dim myconn As OleDbConnection
Dim ad As OleDbCommand
Dim i As Integer, j As Integer
Dim dianliu(0 To 10) As Single
Dim dianya(0 To 10) As Single
For i = 0 To 9
dianliu(i) = 10
dianya(i) = 33
Next
myconn = New OleDbConnection
myconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= D:\Data\Data1.mdb "
myconn.Open()
For j = 0 To 9
ad = New OleDb.OleDbCommand("insert into 表1(nibiandianliu,nibiandianya)values(dianliu(1),dianya(1))", myconn)
ad.ExecuteNonQuery() Next
myconn.Close()
运行时ad.ExecuteNonQuery(）处总是报错，错误提示是：表达式中 'dianliu' 函数未定义。
[解决办法]
一
("insert into 表1(nibiandianliu,nibiandianya)values(dianliu(j),dianya(j))"这是个字符串，里面的
dianliu(j),dianya(j)只不过是字符串的一部分
二
即使你改完了之后每一次 insert into 的参数都是一致的，不会主键冲突吗
[解决办法]
"insert into 表1(nibiandianliu,nibiandianya)values(" & dianliu(1) & "," & dianya(1) & ")"
sorry打错了。。。
