ADO数据库问题？

[sunming]

我用ADO连接字符串方式打开一个数据库后，查询一个记录集，如何把记录集绑定到DATAGRID控件上显示？MSDN介绍中说用Adogrid.showdata Rs 怎么在DATAGRID 中没有SHOWDAT 方法呢？ 为什么我用Set Adodc1.Recordset = rsS 和
Set DataGrid1.DataSource = rsS
DATAGRID 都没有显示记录结果呢？

[Tyro]

设置以后要刷新 adodc1.refresh datagrid1.refresh

[Un1]

Private Sub Form_Load()
Dim conn As Connection
Set conn = New Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\Test.mdb;Persist Security Info=False"

Dim cmd As Command
Set cmd = New Command
Set cmd.ActiveConnection = conn
cmd.CommandText = "test"

Dim rs As Recordset
Set rs = New Recordset
rs.CursorLocation = adUseClient
rs.Open cmd, , adOpenDynamic, adLockBatchOptimistic

Set Adodc1.Recordset = rs

Set DataGrid1.DataSource = rs
End Sub

[sunming]

非常感谢您，原来要执行rs.CursorLocation = adUseClient这条语句！