Как связать ADODB.Recordset с DBGrid
Ниже код
Dim rst As ADODB.Recordset
Dim strConnect As String
Dim strSQL As String
Dim fld As ADODB.Field
strConnect = "Provider=MSDAORA.1;Password=user1;User ID=user1;Data Source=student;Persist Security Info=True"
strSQL = "select * from USER1.RSPDPP_TRANSACTIONS where trnsSrcAcntNum=11001"
Set rst = New ADODB.Recordset
With rst
.Open Source:=strSQL, _
ActiveConnection:=strConnect, _
LockType:=adLockOptimistic
Do While Not .EOF
For Each fld In rst.Fields
'Print fld.Value & ";";
Next
.MoveNext
Loop
' Close the Recordset object.
.Close
Можна ли сразу сказать DBGrid, чтоб он брал инфу с RecordSet