DataGrid1.datasource=rs能显示在
MSFlexGrid11.DataSource=rs 怎么不能显示记录
不行啊! 我的代码如下:===================================================================
Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public Sub OpenCnRs1() If cn.State = adStateOpen Then '判断数据库是否打开,如果打开就关闭
cn.Close
End If
cn.Open "provider=microsoft.jet.oledb.4.0;data source=" + App.Path + "\db1.mdb;" '打开连接 'Jet OLEDB:Database Password=555;Persist Security Info=True"
With rs
.ActiveConnection = cn
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
' .Open strRsSql '打开记录集
End With
End SubPrivate Sub Command1_Click()
Dim aa As Long
Dim strRsOp As String
strRsOp = "select * from 表1,表2 where 表1.id = 表2.id"
Call OpenCnRs1
rs.Open strRsOp
MsgBox rs.Fields.Count
Set MSFlexGrid1.DataSource = rs
MSFlexGrid11.DataSource=rs 怎么不能显示记录
不行啊! 我的代码如下:===================================================================
Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public Sub OpenCnRs1() If cn.State = adStateOpen Then '判断数据库是否打开,如果打开就关闭
cn.Close
End If
cn.Open "provider=microsoft.jet.oledb.4.0;data source=" + App.Path + "\db1.mdb;" '打开连接 'Jet OLEDB:Database Password=555;Persist Security Info=True"
With rs
.ActiveConnection = cn
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
' .Open strRsSql '打开记录集
End With
End SubPrivate Sub Command1_Click()
Dim aa As Long
Dim strRsOp As String
strRsOp = "select * from 表1,表2 where 表1.id = 表2.id"
Call OpenCnRs1
rs.Open strRsOp
MsgBox rs.Fields.Count
Set MSFlexGrid1.DataSource = rs
解决方案 »
- 正则表达式的表达!!!
- C#如何实现VB中AddressOf功能?
- 如何在VB中制作一个gif动画显示并播放的控件
- 请问:将excel表复制到access中的问题
- Beyond,一次迟到的告别
- 问问各位,还是关于Msflexgrid控件,我怎么样把数据全部显示出来?紧急等待
- 求tidestone Formula One 6.1 Library帮助文挡
- 我想在FORM间切换时实现百叶窗、翻转等效果。请高人指点(通过就散分)急
- 存儲過程在VB在怎么用
- 哪位兄弟有发送邮件的代码呀?要求支持smtp验证,可以发送附件(主要)~
- 谁能给一个枚举注册表键值的源代码。
- 请教高手:在VB-IIS环境下如何实现XML编程?
试试
rs.Open strRsOp,cn,1,1