[RESOLVED] ADODB Recordset

[Nervotrep]

Hello,
I'm here again for some help.

Here is what i have,

Dim ConnectionString As String = "Provider=MSDASQL.1;Password=101098;Data Source=main;Persist Security Info=True"
 
        'Create my objects
        Dim conn As New ADODB.Connection
        Dim cmd As New ADODB.Command
        Dim rs As New ADODB.Recordset
 
        Try
            conn.Open(ConnectionString)
            cmd.ActiveConnection = conn
            cmd.CommandText = "SELECT customername FROM customers"
 
       'make a recordset here
 
        Catch ex As Exception
            Debug.WriteLine(ex.Message.ToString)
 
        End Try

I need help build a recordset from that query and displaying it in a datagrid or a flexgrid.

Thanks in advance!