Qt Code:
  1. QSqlQueryModel *model = new QSqlQueryModel(ui->tableView_staffLog);
  2. qry.prepare( "Some Query" );
  3. if( !qry.exec() )
  4. qDebug() << qry.lastError();
  5. else
  6. {
  7. while(qry.next())
  8. {
  9. model->setQuery(qry);
  10. model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
  11. model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
  12. model->setHeaderData(2, Qt::Horizontal, QObject::tr("Depart"));
  13. model->setHeaderData(3, Qt::Horizontal, QObject::tr("Car Reg"));
  14. model->setHeaderData(4, Qt::Horizontal, QObject::tr("Srt Date"));
  15. model->setHeaderData(5, Qt::Horizontal, QObject::tr("End Date"));
  16. model->setHeaderData(6, Qt::Horizontal, QObject::tr("Contact"));
  17. model->setHeaderData(7, Qt::Horizontal, QObject::tr("Photo"));
  18. ui->tableView_staffLog->setModel(model);
  19. }
To copy to clipboard, switch view to plain text mode 

Thanks for your reply I have changed it according to your suggestion unfortunately it didn't help.