Hi,
This is the code for create a conection between QT and SQLite and read data from table.


class Manager : public QMainWindow, private Ui::MainWindow
{
Q_OBJECT
QSqlDatabase db;
QSqlQuery query;

public:
Manager();
~Manager();
bool createConnection();
void LoadData();

public slots:
void play1();
void stop1();
void pause1();
protected:
};


bool Manager::createConnection()
{
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("ManagerDB.db");
if (!db.open()) {
QMessageBox::critical(0, qApp->tr("Cannot open database"),
qApp->tr("Unable to establish a database connection.\n"
"This program needs SQLite support. Please read "
"the Qt SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."), QMessageBox::Cancel);
return false;
}
return true;
}


void Manager::LoadData()
{
QSqlQuery query1 ("select * from TreeList" );
while (query1.next()) {
QString country = query1.value(2).toString();
qDebug( query1.value(2).toString() );
}
}