Question

vb.net向Access数据库表中插入数据总是提示 INSERT INTO 语法错误

如题，下面是我的代码：Const NetTableName As String = "Nets"Dim MyDataSet As New DataSetDim DBPath As String = Application.StartupPath & "\123.accdb"Dim ConStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DBPath & ";Jet OLEDB:Engine Type=5"CreateNetTable(DBPath) '创建数据表Dim DBConn As New OleDbConnection(ConStr)Dim QueryStr As String = "Select * from " & NetTableNameDim DBAdapter As New OleDbDataAdapter(QueryStr, DBConn)Dim CMDBuilder As New OleDbCommandBuilder(DBAdapter)DBAdapter.Fill(MyDataSet, NetTableName)GetNetInfoFromBoard(BoardPath) '把数据填入MyDataSet'把数据存入数据库DBAdapter.Update(MyDataSet, NetTableName) '------就是这一句出错我还有创建2个其它的表，创建表和数据插入都是差不多的，那两个表都没问题，就这个表有问题，不知道是什么原因。
Column.Properties("Jet OLEDB:Allow Zero Length").Value = True 这句话是否是设置这个列的数据允许为空？因为我插入的数据里有的列的内容为空。

我用OleDbCommandBuilder自动生成的Insert语句，我怎么查看它生成的insert语句啊，我在报错后查看了DBAdapter.IndertCommand的值是Nothing.





Answer 1

定义一个OleDbCommand,把OleDbCommandBuilder的insertCommand给他,在语句后面加个断点就能看到

Answer 2

检查一下你这个表的主键呢？