System.Data.SQLite

Hi, I am a newbie in regards to System.Data.SQLite and .NET, so bear with me. I can't seem to get System.Data.SQLite even installed correctly. The self-installer completed and everything seemed to be kosher, but nothing seems to be working. In VC# Express, I tried to create a little sample program(http://pastebin.com/m8f7cec), but it's saying that it can't find System.Data.SQLite at the line: using System.Data.SQLite;. Also the Database explorer always errors out when I try to make a new connection, starting with, "Could not load file or assembly Microsoft.VisualStudio.Data"... I also don't know what to put in the Connection string. Can someone help just get this started? I am familiar with SQLite itself. Thanks.

Hello if I understodd correctly you miss the step to add the reference pointing the .dll of the sqlite, you will find it on program files/sqlite.net

Ah, I see. Thanks. Also, can you point me in the direction of an API? Thanks.

 I'm even more of a newbie than deftonix, and I'm having the same problem, only with VBE 2008.  I installed System.Data.SQLite, I added the "imports" statement to my code, and I'm still getting various errors about undefined commands and empty classes.  Is there some reference to the .dll that will solve my problem (apparently) the way it solved deltonix's?  And if that's the problem, can you provide specific instructions, as detailed as possible, for defining the reference?  I really am a newbie!

 

TIA...