1,216
社区成员
发帖
与我相关
我的任务
分享数据绑定
请问如何使网格（Datagrid,msflexgrid,Mshflexgrid中的任一一种)不通过DATA,ADODC直接连接到数据库(ACCESS）
...全文
请发表友善的回复…
发表回复
xwj1003 2003-03-11
- 打赏
- 举报
同意
northwolves 2003-03-10
- 打赏
- 举报
Dim mycnn As New ADODB.Connection
Dim myrst As New ADODB.Recordset
mycnn.Open "Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\postzip.mdb"
myrst.CursorLocation = adUseClient
myrst.Open "select * from postzip ", mycnn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = myrst
Dim myrst As New ADODB.Recordset
mycnn.Open "Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\postzip.mdb"
myrst.CursorLocation = adUseClient
myrst.Open "select * from postzip ", mycnn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = myrst
