Member Avatar for ADPYvette

I am building an application that needs to access a database. I installed SQLite.net, made references to SQLite for Windows Runtime and Microsoft Visual C++ Runtime Packages.

Now, how do I connect to the database? In other words, what are the Visual Basic codes? Note that I do not see a DataSet or DataGridView in the tools menu like there is in Visual Basic 2008 that I am more familiar with

I am using Visual Studio Express 2012 for Windows 8 (not the desktop version) and I code in Visual Basic.

  • 2 Contributors
  • 2 Replies
  • 205 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by ADPYvette
Member Avatar for Begginnerdev

You will need to find out what library you wish to use.

For example:

System.Data.SQLClient
System.Data.OleDB
System.Data.* 'Microsoft loves re-inventing the wheel

As for the connection, you need to find the correct connection string to the database. (See here.)

Next you will have to determine which method of manipulation is right for you. (Sounds like one of THOSE commercials.)

You can pull down a copy of the data (Using DataAdapters) or manipulate the data "live" (Using DataReaders)

As for the code to connect, it is as simple as:

Dim con As OleDBConnection("MyConnectionStringHere")
con.Open()
Edited by Begginnerdev
Member Avatar for ADPYvette

My knowledge in databases is to limited to decipher your answer. Could you give the complete code.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.