By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,061 Members | 1,539 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,061 IT Pros & Developers. It's quick & easy.

How to display record from sqlite database in visual studio 2005

P: 1
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:

Expand|Select|Wrap|Line Numbers
  1. objConn.Open()
  2. rs = New ADODB.Recordset
  3.  
  4. rs.Open("select * from table", objConn)
  5.  
  6. Do While Not rs.EOF
  7.  
  8.        rs.MoveNext()
  9.  Loop
  10.  
  11. rs.Close()
Any help will be appreciated
Sep 22 '12 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,383
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.
Sep 22 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.