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()

    评论

报告相同问题?

悬赏问题

  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的
  • ¥15 r语言蛋白组学相关问题