SQLite with VB .Net

[taz]

Does anyone have a sample application with VB .Net and a SQLite database? I am having trouble figuring out what the correct database connection is (where the database isn't always in the same location).

Thanks,
Taz

[systemshark]

Taz,

I write in both VB.NET and C#...

Here's a chuck of my code from my Sky Channel Tool Logo which connected to GBPVR Database in Vb.net

imports system.data.sqlite

Public Demo
Public Sub DemoCode
Try
Dim dr As System.Data.DataTableReader
Dim dr2 As System.Data.DataTableReader
Dim ds As New DataSet
Dim ds2 As New DataSet
Dim da As New SQLiteDataAdapter
Dim Conn As New SQLiteConnection
'Dim dbpath As String = Me.TextBox2.Text
Dim sqlCmd As New SQLiteCommand
Dim UpdateCmd As New SQLiteCommand

Dim mysql As String

Dim iloop As Integer
Dim aResult() As String
Dim iPos As Integer

Dim sChannelID As String
Dim sChannelname As String

' Default Connection string looks like:- "Data Source=C:\program files\Devnz\GBPVR\GBPVR.DB3;Compress=False;Synchronous=Off"

Conn.ConnectionString = GBPVRInfo.GBPVRDBConnectionString

SCSError.WriteToErrorLog("OpenSQLLite-Connecting to Database " & GBPVRInfo.GBPVRDBConnectionString, "Download", "SkyChannelSync")

Conn.Open()

Dim strSQL As String = "SELECT rowid as RowID,CHANNEL.Channel_Number,Channel.Name,Channel.OID FROM CHANNEL"
SCSError.WriteToErrorLog("OpenSQLLite-Connecting to Database", "Download", "SkyChannelSync")
sqlCmd.CommandText = strSQL
sqlCmd.CommandType = CommandType.Text
sqlCmd.Connection = Conn

da.SelectCommand = sqlCmd
SCSError.WriteToErrorLog("OpenSQLLite-Reading Records", "Download", "SkyChannelSync")
da.Fill(ds)
sChannelID = ""
dr = ds.CreateDataReader
While dr.Read()

SyncForm.Refresh()

[taz]

Thank you! I will give that a try.

Taz

[saintjo]

Also, dont forget to dispose your SQLLite objects. They are technically calling into unmanaged code and dont always clean up well after themselves. Probably not an issue for what you are programming, but its a good habit to get into.

You can also use the Using () command if you are doing C#. Its just easier to read and fills in the dispose and finalizers for you in the IML code.