Sql query to retrieve database table data

[Cyrebo]

In line 11 You define pointer ui. Next You use this pointer in line 13 and 14 but the pointer is NOT initialised.
I suggest first learn the basics of C++.

I saw this later on and have changed my code quite a bit since that post. At the moment, only 1 label and lineEdit is showing up with 1 record, how do I make it one for each record? And my question on how to loop through all the total number of names from the sql query?

My code now:

QSqlQuery qry;
 
    if (qry.exec("SELECT name FROM customer"))
    {
        while(qry.next())
        {
            qDebug() << qry.value(0).toString();
                if(qry.isValid())
                {
                 QString cust = qry.record().value(0).toString();
                 QLabel *label = new QLabel(QString(cust));
                 QLineEdit *lineEdit = new QLineEdit;
                 lineEdit->setInputMask("0");
                 lineEdit->setMaxLength(1);
                 lineEdit->setGeometry(0,0,41,31);
                 label->setGeometry(0,0,150,41);
 
                 ui->gridLayout->addWidget(label,0,0); //<<<<<<<<<<<Fills the entire width of layout,why?
                 ui->gridLayout->addWidget(lineEdit,0,1);//<<<<<<<<<<<Fills the entire width of layout,why?
                }
        }
    }
    else
    {
        qDebug() << qry.lastError();
    }

QSqlQuery qry;

    if (qry.exec("SELECT name FROM customer"))
    {
        while(qry.next())
        {
            qDebug() << qry.value(0).toString();
                if(qry.isValid())
                {
                 QString cust = qry.record().value(0).toString();
                 QLabel *label = new QLabel(QString(cust));
                 QLineEdit *lineEdit = new QLineEdit;
                 lineEdit->setInputMask("0");
                 lineEdit->setMaxLength(1);
                 lineEdit->setGeometry(0,0,41,31);
                 label->setGeometry(0,0,150,41);

                 ui->gridLayout->addWidget(label,0,0); //<<<<<<<<<<<Fills the entire width of layout,why?
                 ui->gridLayout->addWidget(lineEdit,0,1);//<<<<<<<<<<<Fills the entire width of layout,why?
                }
        }
    }
    else
    {
        qDebug() << qry.lastError();
    }

To copy to clipboard, switch view to plain text mode