how to connect to sqlite database

[ARASHz4]

i want to connect to sqlite database
this is my code:

QSqlDatabase Database;

    Database.addDatabase("QSQLITE");
    Database.setDatabaseName("C:/Users/ARASH/Desktop/arash.db");

    if (!Database.open())
    {
        qDebug() << Database.lastError().text();
    }

but return me "Driver not loaded Driver not loaded"

I copy qsqlite.dll in sqldrivers folder inside my app folder but don't work

[p3c0]

@ARASHz4 That dll should be inside sqldrivers directory.
Have a look at this wiki page.

[panosk]

This post is deleted!

[panosk]

You need to assign the connection like this:

QSqlDatabase Database;

Database = QSqlDatabase::addDatabase("QSQLITE");
Database.setDatabaseName("C:/Users/ARASH/Desktop/arash.db");

if (!Database.open())
{
    qDebug() << Database.lastError().text();
}

[Yugui]

about how to connect to sqlite database, what's the best form to do the connection?, once tiem at start and only get connexion or connect and close on each query.
and is possible do update with bindvalue?

thank you, sorry for my english!

[mrjj]

@Yugui
Often best design is open once at start.
and close at end.

• and is possible do update with bindvalue?

yes. it is.

QSqlQuery query;
query.prepare("INSERT INTO person (id, forename, surname) "
              "VALUES (:id, :forename, :surname)");
query.bindValue(":id", 1001);
query.bindValue(":forename", "Bart");
query.bindValue(":surname", "Simpson");
query.exec();

http://doc.qt.io/qt-5/qsqlquery.html