Pembuatan Database SQLite dengan VB.NET 2005

Categories: Tutorial Database dan Pemrograman

Tutorial ini mencoba menunjukkan bagaimana koneksi dengan SQLite dengan VB.NET 2005.Kita membutuhkan sebuah DLL yang bernama System.Data.SQLite (http://sqlite.phxsoftware.com/) yang bersifat freeware…

Imports System.Data.SQLiteImports System.IO

Private Sub btn_createdb_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_createdb.Click

'Save Dialog Box Dim f As New SaveFileDialog f.Filter = "SQLite 3 (*.db3)|*.db3|All Files|" f.ShowDialog() 'Create Database Dim SQLconnect As New SQLite.SQLiteConnection() 'Database Doesn't Exist so Created at Path SQLconnect.ConnectionString = "Data Source=" & f.FileName & ";" SQLconnect.Open() SQLconnect.Close()

End Sub

Private Sub btn_tables_create_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_tables_create.Click

Dim SQLconnect As New SQLite.SQLiteConnection() Dim SQLcommand As SQLiteCommand SQLconnect.ConnectionString = "Data Source=" & txt_dbpath.Text & ";" SQLconnect.Open() SQLcommand = SQLconnect.CreateCommand 'SQL query to Create Table SQLcommand.CommandText = "CREATE TABLE " & txt_tables_name.Text & "(id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, description TEXT, image BLOB);" SQLcommand.ExecuteNonQuery() SQLcommand.Dispose() SQLconnect.Close()End Sub

Selamat mencoba!