System.Data.SQLite

Hi,

I installed SQLite-1.0.48.0-setup.exe. and I'm using Visual Basic 2005 Express.  I can connect via the database explorer to a sqlite database, but when I want to import System.Data.SQLite I get a green line underneath this line.

I want to connect via code to my database. How can I get the import System.Data.SQLite getting to  work?

Albert

Hi Albert, 

Does the green line tell you anything if your mouse pointer hovers over it? 

Have you tried the following:

Add a reference to System.Data.SQLite by going to  Project - Add Reference and choosing System.Data.SQLite?

Then you can add your 'Imports' statement to the top of your class like:

File name is Form1.vb and the contents are as follows:

Imports System.Data.SQLite
Public Class Form1

End Class

Hope that helps.

JB 

Hi JB,

Thanks for your time! 

I have to come back to you on what the green line tells.

I did add a reference as you wrote. When I type Imports I can choose SQLite..... (Import SQLite.Designer....) , but I'm not able to use Imports Systeem.Data.SQLite. This still give the green line.

I will come back on the description of the green line.

Albert 

SQLite.Designer is the design-time component for Visual Studio.  If when you go to "Add Reference" and System.Data.SQLite is not listed, then hit Browse, and find it in C:\Program Files\SQLite.NET\bin

Robert