qry.prepare( "Some Query" );
if( !qry.exec() )
qDebug() << qry.lastError();
else
{
while(qry.next())
{
model->setQuery(qry);
model
->setHeaderData
(0, Qt
::Horizontal,
QObject::tr("ID"));
model
->setHeaderData
(1, Qt
::Horizontal,
QObject::tr("Name"));
model
->setHeaderData
(2, Qt
::Horizontal,
QObject::tr("Depart"));
model
->setHeaderData
(3, Qt
::Horizontal,
QObject::tr("Car Reg"));
model
->setHeaderData
(4, Qt
::Horizontal,
QObject::tr("Srt Date"));
model
->setHeaderData
(5, Qt
::Horizontal,
QObject::tr("End Date"));
model
->setHeaderData
(6, Qt
::Horizontal,
QObject::tr("Contact"));
model
->setHeaderData
(7, Qt
::Horizontal,
QObject::tr("Photo"));
ui->tableView_staffLog->setModel(model);
}
QSqlQueryModel *model = new QSqlQueryModel(ui->tableView_staffLog);
qry.prepare( "Some Query" );
if( !qry.exec() )
qDebug() << qry.lastError();
else
{
while(qry.next())
{
model->setQuery(qry);
model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("Depart"));
model->setHeaderData(3, Qt::Horizontal, QObject::tr("Car Reg"));
model->setHeaderData(4, Qt::Horizontal, QObject::tr("Srt Date"));
model->setHeaderData(5, Qt::Horizontal, QObject::tr("End Date"));
model->setHeaderData(6, Qt::Horizontal, QObject::tr("Contact"));
model->setHeaderData(7, Qt::Horizontal, QObject::tr("Photo"));
ui->tableView_staffLog->setModel(model);
}
To copy to clipboard, switch view to plain text mode
Bookmarks