void MainWindow::on_AdminPB_clicked()
{
//*******************************************************
//* Retrieve data from the USER table for managing... *
//*******************************************************
usertablemodel->setTable ("user");
usertablemodel->sort (0, Qt::AscendingOrder);
usertablemodel->select ();
usertablemodel->setHeaderData (0, Qt::Horizontal,
usertablemodel->setHeaderData (1, Qt::Horizontal,
usertablemodel->setHeaderData (2, Qt::Horizontal,
usertablemodel->setHeaderData (3, Qt::Horizontal,
usertablemodel->setHeaderData (4, Qt::Horizontal,
usertablemodel->setHeaderData (5, Qt::Horizontal,
usertablemodel->setHeaderData (6, Qt::Horizontal,
ui->ManageUsersTV->setModel (usertablemodel);
ui->ManageUsersTV->resizeColumnsToContents ();
}
void MainWindow::on_AdminPB_clicked()
{
//*******************************************************
//* Retrieve data from the USER table for managing... *
//*******************************************************
usertablemodel = new QSqlTableModel(this);
usertablemodel->setTable ("user");
usertablemodel->sort (0, Qt::AscendingOrder);
usertablemodel->setEditStrategy (QSqlTableModel::OnManualSubmit);
usertablemodel->select ();
usertablemodel->setHeaderData (0, Qt::Horizontal,
QObject::tr("Username"));
usertablemodel->setHeaderData (1, Qt::Horizontal,
QObject::tr("Password"));
usertablemodel->setHeaderData (2, Qt::Horizontal,
QObject::tr("Full Name"));
usertablemodel->setHeaderData (3, Qt::Horizontal,
QObject::tr("Status"));
usertablemodel->setHeaderData (4, Qt::Horizontal,
QObject::tr("Access Level"));
usertablemodel->setHeaderData (5, Qt::Horizontal,
QObject::tr("User Name"));
usertablemodel->setHeaderData (6, Qt::Horizontal,
QObject::tr("Activity Date"));
ui->ManageUsersTV->setModel (usertablemodel);
ui->ManageUsersTV->resizeColumnsToContents ();
ui->ManageUsersTV->setEditTriggers (QAbstractItemView::AnyKeyPressed |
QAbstractItemView::DoubleClicked);
}
To copy to clipboard, switch view to plain text mode
Bookmarks