Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Sql As String
'连接数据库(Access)
Set cn = New ADODB.Connection
With cn
.Provider = "MSDataShape.1" '一定要加这句
.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\basic.mdb;" & _
"Persist Security Info=False"
End With
'组合查询语句:
Sql = "SELECT * FROM Tbasic " & _
"where 姓名 ='李明"
Set rs = New ADODB.Recordset
rs.Open Sql, cn, adOpenStatic, adLockReadOnly
Set DataReport1.DataSource = rs
用MSHFlexgrid可以显示出来。可是用datareport显示不出。不知道为什么,请教了,谢谢。。
Dim rs As ADODB.Recordset
Dim Sql As String
'连接数据库(Access)
Set cn = New ADODB.Connection
With cn
.Provider = "MSDataShape.1" '一定要加这句
.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\basic.mdb;" & _
"Persist Security Info=False"
End With
'组合查询语句:
Sql = "SELECT * FROM Tbasic " & _
"where 姓名 ='李明"
Set rs = New ADODB.Recordset
rs.Open Sql, cn, adOpenStatic, adLockReadOnly
Set DataReport1.DataSource = rs
用MSHFlexgrid可以显示出来。可是用datareport显示不出。不知道为什么,请教了,谢谢。。
不知对否?