littlebigman
Well-known member
- Joined
- Jan 5, 2010
- Messages
- 75
- Programming Experience
- Beginner
Hello,
I'm learning VB.Net 2008 and would like to make sure this is the right way to open/close the connection to an SQLite database file:
Thank you.
I'm learning VB.Net 2008 and would like to make sure this is the right way to open/close the connection to an SQLite database file:
VB.NET:
Public Class Form1
'Declare SQLite variables globally since must be accessed by Form + BackgroundWorker threads
Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLite.SQLiteCommand
Dim SQLtransaction As SQLite.SQLiteTransaction
Dim SQLreader As SQLite.SQLiteDataReader
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SQLconnect.ConnectionString = "Data Source=test.sqlite;"
SQLconnect.Open()
SQLcommand = SQLconnect.CreateCommand
'1. Empty DB, read all files from UE backup directory, and update DB
SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS files (id INTEGER PRIMARY KEY AUTOINCREMENT, hash TEXT)"
SQLcommand.ExecuteNonQuery()
SQLcommand.CommandText = "DELETE FROM files; VACUUM"
SQLcommand.ExecuteNonQuery()
SQLcommand.CommandText = "CREATE INDEX IF NOT EXISTS index_hash ON files(hash)"
SQLcommand.ExecuteNonQuery()
End Sub
Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
SQLcommand.Dispose()
SQLconnect.Close()
End Sub
End Class
Thank you.