How to connect to an SQLite database in Visual Studio

Hi
I have Visual Studio community 2015 Update1 running on windows 7 64bit


This page only seems to provide links to 2015 update 3

Once I've installed the correct extensions and added to my first DB project using a windows application
how do I show  the results of a query on a user form?
LVL 1
trevor1940Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
Hi trevor,
For this you need to follow the steps , pls refer this - https://swinbrain.ict.swin.edu.au/wiki/Using_SQLite_within_Visual_Studio

Basically 3 steps-

1. Download the ado.net provider
2. Connection to sqllite DB
3. Use the connection
0
trevor1940Author Commented:
The link you provided points to a version of ADO no longer supported this  in turn points to the the download page in my opening remarks

I've attempted to  install sqlite-netFx46-setup-bundle-x64-2015-1.0.106.0.exe  from that page but don't have the required data connectors in visual studio

iSqliteADO.JPG
0
trevor1940Author Commented:
Maybe I've not asked correctly

Which version of System.Data.SQLite do I need
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Pawan KumarDatabase ExpertCommented:
I think you should use the latest version.
0
trevor1940Author Commented:
I think you should use the latest version.

I did and I'm no further forward
0
trevor1940Author Commented:
I've fixed this myself


Found this page it says to find the reight version with

This is the only setup package that is capable of installing the design-time components for Visual Studio 2015.

for me its the Setups for 32-bit Windows (.NET Framework 4.6)

sqlite-netFx46-setup-bundle-x86-2015-1.0.106.0.exe
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Pawan KumarDatabase ExpertCommented:
glad you got it. Cheers.
0
sarabandeCommented:
for me its the Setups for 32-bit Windows (.NET Framework 4.6)

Visual Studio itself is a 32-bit windows application. you can verify that it installs under 'Program Files (x86)'. nevertheless you could use VS to create 64-bit applications (a similar thing happened 25 years ago when vs went from 16-bit to 32-bit). so all tools and wizards and dll's around VS are 32-bit windows programs as well because 32-bit modules cannot be mixed with 64-bit and vice versa.

Sara
0
trevor1940Author Commented:
Expert solution didn't solve the problem  I did

In this context I'm being generous saying he assisted, read entire question for further details
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.