How send result query database to List<QString>

[bartes19]

I would like send value from two column table Qtableview (value int and varchar) to Qcombobox

query: select kod_lekarstwa, nazwa from lekarstwo;


I think about such loop:

for (list<QString>::iterator it=diseases.begin(); it != diseases.end(); ++it)
{
ui->diseasecomboBox->addItem(*it);
}

[anda_skoa]

You can use QString::number() to convert the int value to a string and then use the + operator to concatenate with the second part.
That string can then easily be appended to a QStringList (which is a QList<QString>)

Cheers,
_

[bartes19]

on start we try to do on the one column , only String values
select nazwa from lekarstwo;

it works, but I don't know how appended result query to QList

QList<QString> list;
      list << "item1" << "item2" << "item3"; 
 
      QString s;
      foreach( s, list )
      {
        qDebug() << s;
        ui->comboBoxmedicine->addItem(s);
      }

QList<QString> list;
      list << "item1" << "item2" << "item3"; 

      QString s;
      foreach( s, list )
      {
        qDebug() << s;
        ui->comboBoxmedicine->addItem(s);
      }

To copy to clipboard, switch view to plain text mode 

[anda_skoa]

I am afraid I don't understand.
Your code already adds strings to the list, i.e. you already know how the << operator works.

Cheers,
_

[bartes19]

Something like that?

list << query.exec("select kod_lekarstwa, nazwa from lekarstwo;");

[anda_skoa]

exec() returns a bool.

You want to loop over the results. See the example in the documentation for QSqlQuery.

Cheers,
_