如何用记录集初始化非绑定的网格控件
这段代码是想用一记录集初始化一非绑定的DBGrid控件。
运行正常,但DBGrid控件中没有记录。
Private Sub Form_Load()
Dim en As rdoEnvironment
Dim cn As rdoConnection
Dim rs As rdoResultset
Dim myRow As Long
Set en = rdoEngine.rdoEnvironments(0)
Set cn = en.OpenConnection("odbc;dsn=as400/db2;",rdOpenKeyset)
Set rs = cn.OpenResultset("select iprod,idesc from
v623fset.iiml01 where left(iprod,2) = '99'",rdOpenKeyset)
With DBGrid1
.AllowAddNew = True
Do Until rs.EOF
.Columns(0) = rs!iprod
.Columns(1) = rs!idesc
rs.MoveNext
Loop
End With
cn.Close
en.CloseEnd
Sub