jeudi 22 octobre 2015

vb.net SQLite Password

I am using VB.net and I am creating a database. The part I can't seem to get working is how to make it have a password.

The code I am using is:

Imports Finisar.SQLite


Public Class Form1
    Const CONNECTION_STR As String = "Data Source=customers.db;Version=3;"

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        CreateDatabase()
    End Sub

    Private Sub CreateDatabase()
        '===================================================
        ' Create a new database and populate it with some data
        '===================================================

        'Declare the main SQLite data access objects
        Dim objConn As SQLiteConnection
        Dim objCommand As SQLiteCommand

        Try
            'Create a new database connection
            'Note - use New=True to create a new database
            objConn = New SQLiteConnection(CONNECTION_STR & "New=True;")

            'Open the connection
            objConn.Open()

            'Create a new SQL command
            objCommand = objConn.CreateCommand()

            'Setup and execute the command SQL to create a new table
            objCommand.CommandText = "CREATE TABLE customer (id integer primary key, name varchar(100));"
            objCommand.ExecuteNonQuery()

            'Insert a couple of records into the table
            objCommand.CommandText = "INSERT INTO customer (id, name) VALUES (1, 'John Smith');"
            objCommand.ExecuteNonQuery()
            objCommand.CommandText = "INSERT INTO customer (id, name) VALUES (2, 'Jane Jones');"
            objCommand.ExecuteNonQuery()

        Finally
            'Cleanup and close the connection
            If Not IsNothing(objConn) Then
                objConn.Close()
            End If
        End Try

    End Sub
End Class

The above works and creates the database but I can't get it to have a password when it creates it.

I have tried changing this line:

objConn = New SQLiteConnection(CONNECTION_STR & "New=True;")

with:

objConn = New SQLiteConnection(CONNECTION_STR & "New=True;Password=myPassword;")

Except it fails to work. I noticed that it comes up saying password is not a valid parameter.

The question I like to know how can I add a password to the database so it requires a password to open it?

Aucun commentaire:

Enregistrer un commentaire