注册 登录
编程论坛 ACCESS论坛

请教一个VB与ACCESS数据库连接的问题,谢谢了

lawless 发布于 2007-04-29 17:21, 2286 次点击

小第想用VB编程把不同组的数据写入数据库不同的表中,部分程序如下,但不行,请问我这段程序错在那了????谢谢!

Private myrs As New ADODB.Recordset
Private mycon As New ADODB.Connection

Dim strConn As String

If st = "59280" Then

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\shujuku.mdb;Persist Security Info=False"

mycon.CursorLocation = adUseClient

mycon.Open strConn

myrs.Open "Select * from qywd", mycon, adOpenKeyset, adLockOptimistic

Set DataGrid1.DataSource = myrs

ElseIf st = "59087" Then

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\shujuku.mdb;Persist Security Info=False"

mycon.CursorLocation = adUseClient

mycon.Open strConn

myrs.Open "Select * from fgwd", mycon, adOpenKeyset, adLockOptimistic

Set DataGrid1.DataSource = myrs

End If

4 回复
#2
bygg2007-04-30 09:31
你加个 Try....Catch...看一下是什么错..
#3
风月_无边2007-04-30 21:48
需要执行多次吧
#4
C之小菜2007-05-01 10:35
细心点应该没错
#5
jxyga1112008-06-20 18:54
调试
1