Looping through query results and displaying in tableview

[gabor53]

Hi,
My intention is to use the following code to read all the data from the database and list them in tableview. ```
//your code #include "mainwindow.h"
#include "ui_mainwindow.h"

MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);

QSqlDatabase db;
       db = QSqlDatabase::addDatabase ("QSQLITE");
       db.setDatabaseName ("C:/Programming/Qtsamples/Image_from_db_to_Table/db.db");

       if(!db.open ())
       {
           qDebug() << "The database is NOT open!";
       }
       else
       {
           qDebug() << "The database is open!";
       }

       QSqlQuery query("SELECT * FROM Items ");


       if(query.isActive()==true)
         {
             qDebug() << "The query is active.";
         }
         else
         {
            qDebug() << "The query is NOT active.";
         }

       QSqlQuery query2 ("SELECT Count(*) FROM Items");

		int count;
       query2.first ();
        count = query2.value (0).toInt ();

		qDebug() << "The number of rows: " << count;

		//query.first ();
        QStandardItemModel *smodel = new QStandardItemModel;

        int ID;

		ui->tableView->setModel (smodel);

while(query.next ())
{

                QStandardItem *Item = new QStandardItem();
                QStandardItem *Item2 = new QStandardItem();

                Item->setData (ID = query.value (0).toInt (),Qt::DisplayRole);
                qDebug() << "ID = " <<   ID;
                smodel->setItem (0,0,Item);

                QByteArray ByteArray;
                ByteArray = query.value (1).toByteArray ();
                QPixmap Pixmap;
                Pixmap.loadFromData (ByteArray);
                Pixmap = Pixmap.scaled (100,100,Qt::KeepAspectRatio);

                Item2->setData (QVariant(Pixmap),Qt::DecorationRole);

                smodel->setItem (0,1,Item2);
                ui->tableView->;

        }

				ui->tableView->resizeColumnsToContents ();
				ui->tableView->resizeRowsToContents ();
      			ui->tableView->horizontalHeader ()->setStyleSheet ("QHeaderView{font: 14pt Arial; color: blue; font-weight: bold;}");

      smodel->setHeaderData (0,Qt::Horizontal, QObject::tr ("ID"));

      smodel->setHeaderData (1,Qt::Horizontal, QObject::tr ("Picture"));

	db.close ();

}

MainWindow::~MainWindow()
{
delete ui;
}

The code only lists the first item in the database. Please help me to find what I did wrong. Thank you.

[mrjj]

@gabor53 said:
Well the query seems fine.
But one thing I did wonder;

smodel->setItem (0, 0, Item);
smodel->setItem (0, 1, Item2);

You inset as same row ? (0)
I imagine something like

int row=0
while(query.next ()) {
...
smodel->setItem (row, 0, Item);
smodel->setItem (row++, 1, Item2);
...

Also for viewing, there is also
http://doc.qt.io/qt-5.5/qsqlquerymodel.html#details

[gabor53]

Thank you. It worked.