SQLite - filebasierte Datenbank

[localhorst]

Verbindung zur DB herstellen / DB anlegen

Code: Alles auswählen

Dim connect As New SQLite.SQLiteConnection()
connect.ConnectionString = "Data Source=user.s3db;"
connect.Open()
connect.Close()

Query an die DB stellen

Code: Alles auswählen

Dim command As New SQLite.SQLiteCommand
connect.Open()
command = connect.CreateCommand
command.CommandText = "CREATE TABLE user(id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT);"
command.ExecuteNonQuery()
command.Dispose()

Query-Beispiele (Insert, Delete, Update)

Code: Alles auswählen

command.CommandText = "INSERT INTO table(column1,column2) VALUES ('value1','value2');"
command.CommandText = "DELETE FROM table WHERE id ='1';"
command.CommandText = "UPDATE table SET column1,column2 = 'value1','value2';"
connect.Close()

Sonderbehandlung bei SELECT-Query

Code: Alles auswählen

Dim SQLreader As SQLiteDataReader = command.ExecuteReader()

connect.Open()
command = connect.CreateCommand
command.CommandText = "SELECT value1,value2 FROM table"
While SQLreader.Read()
   value1 = sqlreader(0)
   value2 = sqlreader(1)
End While
command.Dispose()
connection.Close()

GUI-DB-Editor
Zum Erstellen der DB und Tabellen usw. empfiehlt sich das das Firefox-Plugin "SQLite Manager".

VB.NET Library
http://sqlite.phxsoftware.com/