zsyyx 2016-11-20 14:32 采纳率: 0%
浏览 1301

vb连接access数据库出现无法找到表0

Imports System.Data.OleDb

Public Class Form1
Dim cn As OleDbConnection
Dim da As OleDbDataAdapter
Dim ds As DataSet
Dim a As Integer = 0
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\db1.mdb;Persist Security Info=False"
cn = New OleDbConnection(cnStr)
Dim sql As String = "select * from s"
da = New OleDbDataAdapter(sql, cn)
ds = New DataSet
da.Fill(ds, "s")
DataGridView1.DataSource = ds.Tables(0)
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim cnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\db1.mdb;Persist Security Info=False"
    cn = New OleDbConnection(cnStr)
    a = a + 1
    Dim m = a
    Dim sql As String = "insert into s(sNo,SN,Sex,Age,Dept) values ('" & m & " ','" & "21" & " ','" & "男" & " ','" & "21" & " ','" & "呵呵" & "')"
    da = New OleDbDataAdapter(sql, cn)
    ds = New DataSet
    da.Fill(ds, "s")
    DataGridView1.DataSource = ds.Tables(0)
    cheshi()   //注释
End Sub

Private Sub cheshi()
    Dim cnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\db1.mdb;Persist Security Info=False"
    cn = New OleDbConnection(cnStr)
    Dim sql As String = "select * from s"
    da = New OleDbDataAdapter(sql, cn)
    ds = New DataSet
    da.Fill(ds, "s")
    DataGridView1.DataSource = ds.Tables(0)
End Sub

End Class


cheshi是重新读取可以。
但是不知道为什么DataGridView1.DataSource = ds.Tables(0),这个会出现错误,无法找到表0,
我的目的是更新表。但是,在刚才那个地方会直接崩溃,不知道为什么。
应该怎么修改,谢谢。

  • 写回答

2条回答 默认 最新

  • threenewbee 2016-11-20 15:16
    关注

    cn = New OleDbConnection(cnStr)
    cn.Open()

    评论

报告相同问题?

悬赏问题

  • ¥15 matlab求解平差
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料
  • ¥15 使用R语言marginaleffects包进行边际效应图绘制
  • ¥20 usb设备兼容性问题
  • ¥15 错误(10048): “调用exui内部功能”库命令的参数“参数4”不能接受空数据。怎么解决啊
  • ¥15 安装svn网络有问题怎么办
  • ¥15 vue2登录调用后端接口如何实现
  • ¥65 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?