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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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
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
trevor1940Author Commented:
Maybe I've not asked correctly

Which version of System.Data.SQLite do I need
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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

I did and I'm no further forward
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

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.
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
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
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.