How to display record from sqlite database in visual studio 2005

[calv]

Hi,
I am using visual studio 2005 for a project and i am using ADODB connection to connect to the sqlite database.

I would like to know how do i read and display record from the sqlite database onto the messagebox? Below is partial code from the program:

objConn.Open()
rs = New ADODB.Recordset

rs.Open("select * from table", objConn)
            
Do While Not rs.EOF
                
       rs.MoveNext()
 Loop

rs.Close()

Any help will be appreciated

[Rabbit]

Please use code tags when posting code.

I don't see a message box anywhere in your code. Also, I'm not really sure what you question is. You just have to reference the field you want to display when you call the message box.