Search code examples
c#vb6vb6-migration

I don't know what ADODB.Recordset is


I am converting a VB6 app to C#. I am starting on the top of the VB6 app and going from there. What is all the RS. stuff? I don't understand?

Sub Main()
    Dim RS As ADODB.Recordset
    Dim FileName As String, FilePath As String
    Dim Test As Boolean
    Dim ResultCode As xcdError

    Dim oAccess As Access.Application
    Dim Zip_File As String

    On Error GoTo ErrorHandler

    ' Make a connection to the database
    Call MakeDBConnection

    ' Create a recordset of the directories to check
    Set RS = New ADODB.Recordset

    RS.ActiveConnection = DB
    RS.CursorType = adOpenDynamic
    RS.LockType = adLockOptimistic
    RS.Open "Select ConversionDefinition.* From ConversionDefinition"
    ' Check the directories for Raw Data
    ' If the required data is found, then start the coversion application
    If Not (RS.EOF And RS.BOF) Then
        RS.MoveFirst
        Do While Not (RS.EOF)

Solution

  • You should read this

    The page explains it pretty well. It is an ADO DabaBase RecordSet.