Private Sub Command3_Click()
Dim str As String
Dim conn As Connection
Dim rs As Recordset
Set conn = New Connection
Set rs = New Recordset
sdbname = App.Path + "\net1.mdb"
sPassword = ""
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
SQL = "Select * from ask"
rs.Open SQL, conn, 1, 3
For i = 1 To rs.RecordCount
List1.AddItem rs("姓名")
rs.MoveNext
Next i
Command1.Enabled = False
End Sub
当我运行点击,按钮时就提示 “Connection 用户类型未定义,”为什么会出现这个,应该怎么解决,请各位大哥多多帮忙!
Dim str As String
Dim conn As Connection
Dim rs As Recordset
Set conn = New Connection
Set rs = New Recordset
sdbname = App.Path + "\net1.mdb"
sPassword = ""
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
SQL = "Select * from ask"
rs.Open SQL, conn, 1, 3
For i = 1 To rs.RecordCount
List1.AddItem rs("姓名")
rs.MoveNext
Next i
Command1.Enabled = False
End Sub
当我运行点击,按钮时就提示 “Connection 用户类型未定义,”为什么会出现这个,应该怎么解决,请各位大哥多多帮忙!
Private Sub Command1_Click()
Dim sql As String
Dim sdbname As String
Dim sPassword As String
Dim str As String
Dim conn As adodb.Connection
Dim rs As adodb.Recordset
Set conn = New adodb.Connection
Set rs = New adodb.Recordset
sdbname = App.Path + "\net1.mdb"
sPassword = ""
sql = "Select * from ask"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
conn.Open
rs.CursorLocation = adUseClient
rs.Open sql, conn, adOpenStatic, adLockReadOnly
'Set DataGrid1.DataSource = rs
For i = 1 To rs.RecordCount
List1.AddItem rs("姓名")
rs.MoveNext
Next i
End Sub
在建立了VB的数据工程后,移去原数据工程的窗体,添加你自己代码的窗体。
再执行你的代码。
Microsoft ActiveX Data Object ... (很多版本)