Querying a database and populating a combobox

[Lykurg]

Use a QSqlQueryModel and set it via QComboBox::setModel() to your combobox. Then you can get all the information of the query through the normal index approach.

[Splatify]

Could you please give me an example of how to do this.... I've been messing about for hours now and I don't seem to be getting anywhere.

Thanks for your time and trouble

[kornicameister]

setModel method of QComboBox is reimplemented, it's argument is QAbstractItemModel
do as Lykurg suggested you to do, and simple use setModel to set QSqlQueryModel model for combo box

check the documentation of QSqlQueryModel if you do not know which method use to set the query

[Splatify]

Ok so this is what I have done so far:

QString querystring = "SELECT u.UserID, f.FileName, f.FileLocation, s.Size, s.Finished FROM users u JOIN stats s ON s.UserID = u.UserID JOIN file f ON s.FileID = Q.FileID WHERE u.UserID = 1";
 
    QSqlQuery modelquery;
 
    modelquery.exec(querystring);
    QSqlQueryModel *model = new QSqlQueryModel;
    model->setQuery(modelquery);
    model->setHeaderData(0, Qt::Horizontal, "UserID");
    model->setHeaderData(1, Qt::Horizontal, "File Name");
    model->setHeaderData(2, Qt::Horizontal, "File Location");
    model->setHeaderData(3, Qt::Horizontal, "Size");
    model->setHeaderData(4, Qt::Horizontal, "Finished");

QString querystring = "SELECT u.UserID, f.FileName, f.FileLocation, s.Size, s.Finished FROM users u JOIN stats s ON s.UserID = u.UserID JOIN file f ON s.FileID = Q.FileID WHERE u.UserID = 1";

    QSqlQuery modelquery;

    modelquery.exec(querystring);
    QSqlQueryModel *model = new QSqlQueryModel;
    model->setQuery(modelquery);
    model->setHeaderData(0, Qt::Horizontal, "UserID");
    model->setHeaderData(1, Qt::Horizontal, "File Name");
    model->setHeaderData(2, Qt::Horizontal, "File Location");
    model->setHeaderData(3, Qt::Horizontal, "Size");
    model->setHeaderData(4, Qt::Horizontal, "Finished");

To copy to clipboard, switch view to plain text mode 

so then i have to update my combobox with this model. I can do this by doing:

ui->ComboBox->setModel(model);

ui->ComboBox->setModel(model);

To copy to clipboard, switch view to plain text mode 

However this puts the UserID in the combo box. How do i show the Filename in the combo box and then how do i use the model so when a particular file is selected within the combobox, the file location of the selected file is used in another function.

Thanks for your time and trouble

[Lykurg]

See the modelColumn property or simply query the filename as the first element in your query. Further make the model a member variable then you can access it in the slot and get the value by using QSqlQueryModel::record().

[Splatify]

Ok so now i have this:

ui->QuizBox->setModel(model);
    ui->QuizBox->setModelColumn(1);

ui->QuizBox->setModel(model);
    ui->QuizBox->setModelColumn(1);

To copy to clipboard, switch view to plain text mode 

I'm still unsure of how to use this model. Could you give me some example code of how to use the model when an item is selected in the combobox and a button is pressed.

Thanks very much