Link a Form with SQL Server Table with Code 1

[7025]

How can i create an open recordset for the form in vb6 ? (i want to open it with CODE, if with ADODC object i already know how it works). I already open the connection with the database. Is there any one can help me?

 

[SonOfEmidec1100]

This example should give you the basic idea, you will need to change the property values to meet your needs (probably).

    Dim lrs As ADODB.Recordset
    
    Set lrs = New ADODB.Recordset
    With lrs
        Set .ActiveConnection = MyConnection
        .CursorType = adOpenForwardOnly
        .CursorLocation = adUseClient
        .LockType = adLockReadOnly
        .Open "SELECT * FROM MyTable"
    End With