MySql data not shown in QcomboBox

[anda_skoa]

qry.prepare("SELECT * FROM templateinfo WHERE FaceID='"+Face+"'");

qry.prepare("SELECT * FROM templateinfo WHERE FaceID='"+Face+"'");

To copy to clipboard, switch view to plain text mode 

Don't concatenate values onto an QSL query, use QSqlQuery::bindValue() instead.

void FormDialog::on_loadData_clicked()
{
    connOpen();
    QSqlQueryModel * modal = new QSqlQueryModel();
    QSqlQuery* qry = new QSqlQuery(db);
    qry->prepare("SELECT FaceID FROM templateinfo");
    qry->exec();
    modal->setQuery(*qry);
 
    ui->comboBox->setModel(modal);
 
    qry->next();
    qDebug() << (modal->rowCount());
 
}

void FormDialog::on_loadData_clicked()
{
    connOpen();
    QSqlQueryModel * modal = new QSqlQueryModel();
    QSqlQuery* qry = new QSqlQuery(db);
    qry->prepare("SELECT FaceID FROM templateinfo");
    qry->exec();
    modal->setQuery(*qry);

    ui->comboBox->setModel(modal);

    qry->next();
    qDebug() << (modal->rowCount());

}

To copy to clipboard, switch view to plain text mode 

A coupe of things for this:
- no need to create the model every time, just create it once and keep it in a member variable.
- you then only need to set it once one the table as well
- Don't create the query on the heap, you are leaking it
- in fact you can just pass the SQL string to the model
- see if you have the data you expect inside the model, e.g

qDebug() << model->index(0, 0).data(Qt::DisplayRole);

qDebug() << model->index(0, 0).data(Qt::DisplayRole);

To copy to clipboard, switch view to plain text mode 

or create a QTableView (without parent it becomes a separte window) and let it have the same model

Cheers,
_