I'm posting these codes to try to help you solve your problem. It works on my simple database project.
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(":genes:");
QSqlTableModel *empmodel = new QSqlTableModel();
empmodel->setTable("person");
empmodel->select(); // populate records
QString s;
s= s.setNum(empmodel->rowCount()); // returns the number of rows
this->setWindowTitle(s); // display it
empmodel->setHeaderData(0, Qt::Horizontal, tr("ID"));
empmodel->setHeaderData(1, Qt::Horizontal, tr("NAME"));
empmodel->setHeaderData(2, Qt::Horizontal, tr("ADDRESS"));
QTableView *empview = new QTableView();
empview->setModel(empmodel);
empview->resize(QSize::QSize(800,250));
empview->resizeColumnsToContents();
empview->show();
Bookmarks