Re: [sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

[Gilles Ganault]

On Mon, 25 Mar 2013 17:46:17 -0400,
 wrote:
>I installed slqite, its sqlite3 command line interface, and a GUI admin 
>console. Have built and populated a couple of databases. But what I really 
>want to do is to connect to sqlite databases from Visual Studio 2012 using 
>Visual Basic.
>
>Downloaded and installed the SourceForge System.Data.SQLite adaptor... now 
>what?  Is there a set of instructions somewhere for Creating a VS/VB 2012 
>project, creating a windows form, and enabling an ADO.NET adaptor to sqlite?
>
>The instructions on these two pages do not work for me:
>http://www.ehow.com/how_11386220_use-sqlite-vbnet.html
>http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Been there recently.

After installing the .Net SQLite package*, I simply created a new
VB.Net Form project, added a reference to the DLL (Project > Add
Reference), and typed some test code, eg.

www.kirupa.com/net/sqllite_vb_pg1.htm

HTH.

 * there are fundamentaly three of them at their new home
(http://system.data.sqlite.org/). As I didn't get an answer as to when
I would need the setup packages  ("intended to be installed only on
developer machines and then only when the design-time components for
Visual Studio are required"), I downloaded and unzipped the one that
seems recommended for most users, which is the Precompiled Binaries +
no-bundle "sqlite-netFx20-static-binary-Win32-2005-1.0.84.0.zip".

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

[Larry Brasfield]

larrygauthier at charter.net writes:

I installed slqite, its sqlite3 command line interface, and a GUI admin
console. Have built and populated a couple of databases. But what I really
want to do is to connect to sqlite databases from Visual Studio 2012 using
Visual Basic.

Downloaded and installed the SourceForge System.Data.SQLite adaptor... now
what?  Is there a set of instructions somewhere for Creating a VS/VB 2012
project, creating a windows form, and enabling an ADO.NET adaptor to sqlite?

The instructions on these two pages do not work for me:
http://www.ehow.com/how_11386220_use-sqlite-vbnet.html
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Help needed. Thanks in advance.


For information specific to the ADO.NET adapter for SQLite, start at:
  http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki
.

How to create a VB project, use Visual Studio, or program using the 
ADO.NET APIs is off-topic here.  There is a wealth of information on the 
net regarding those topics.  You can find it.


I will add, (approaching the border of topicality here), that the 
adapter adheres closely to what the API designers had in mind and have 
documented, allowing me to take code which works with the SQL Server 
Compact Edition and use it nearly unchanged with SQLite.  The developers 
anticipate and well support such scenarios.


Cheers,
--
Larry Brasfield

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

[larrygauthier]

I installed slqite, its sqlite3 command line interface, and a GUI admin 
console. Have built and populated a couple of databases. But what I really 
want to do is to connect to sqlite databases from Visual Studio 2012 using 
Visual Basic.


Downloaded and installed the SourceForge System.Data.SQLite adaptor... now 
what?  Is there a set of instructions somewhere for Creating a VS/VB 2012 
project, creating a windows form, and enabling an ADO.NET adaptor to sqlite?


The instructions on these two pages do not work for me:
http://www.ehow.com/how_11386220_use-sqlite-vbnet.html
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Help needed. Thanks in advance.

-larry

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users