QComboBox and DB, how to get ID?

Question

Qt

I get the ID like this:

....
Region= new QComboBox;   
qry.exec("SELECT * FROM region");
model->setQuery(qry);
Region->setModel(model);
Region->setModelColumn(3);

connect(Region, SIGNAL(currentTextChanged(QString)), SLOT(comboChange(QString)));

void MyWidget::comboChange(QString str)
{
    QSqlQuery qry1;
    qry1.prepare("SELECT region_id FROM region WHERE name=?");
    qry1.addBindValue(str);
    qry1.exec();
    int reg;
    while(qry1.next())
        reg = qry1.value(0).toInt();
    //qDebug() << reg;
    emit toRegion(reg);
}
.......

With my zero experience, it seems to me that this is nonsense, albeit somehow working. Tell me the right way.

Answer 1

Use QComboBox::setItemData() when filling the combobox: you can add data invisible to the user to the items. In comboChange QComboBox::itemData() will allow them to be received.

Answer 2

I would use the QComboBox::currentIndexChanged(int index) signal, and in the slot I would refer to the model in the combobox.