写了个vb.net 测试sqlite 代码,报错,急求解决!
Dim conn As System.Data.SQLite.SQLiteConnection
conn = New SQLiteConnection("Data Source=d:\northwindEF.db;Pooling=true;FailIfMissing=false")
conn.Open()
Dim sa As New SQLiteDataAdapter("select * from customers ", conn)
Dim ds As New System.Data.DataSet
sa.Fill(ds)
Dim mytable As New System.Data.DataTable
mytable = ds.Tables(0)
Me.DataGridView1.DataSource = mytable
Me.DataGridView1.Refresh()
ds.Tables(0).Rows(0).Item(1) = "88"
Me.DataGridView1.Refresh()
sa.Update(ds)
错误提示
System.InvalidOperationException:“当传递具有已修改行的 DataRow 集合时,更新要求有效的 UpdateCommand。”
我用oledb访问acess数据库时候 没出过这个错误