FormDialog::FormDialog() { QLabel *forenameLabel = new QLabel( "Forename:", this ); QLabel *forenameDisplay = new QLabel( this ); QLabel *surnameLabel = new QLabel( "Surname:", this ); QLabel *surnameDisplay = new QLabel( this ); QLabel *salaryLabel = new QLabel( "Salary:", this ); QLineEdit *salaryEdit = new QLineEdit( this ); QGridLayout *grid = new QGridLayout( this ); grid->addWidget( forenameLabel, 0, 0 ); grid->addWidget( forenameDisplay, 0, 1 ); grid->addWidget( surnameLabel, 1, 0 ); grid->addWidget( surnameDisplay, 1, 1 ); grid->addWidget( salaryLabel, 2, 0 ); grid->addWidget( salaryEdit, 2, 1 ); grid->activate(); QSqlCursor staffCursor( "staff" ); staffCursor.select(); staffCursor.next(); QSqlForm sqlForm( this ); sqlForm.setRecord( staffCursor.primeUpdate() ); sqlForm.insert( forenameDisplay, "forename" ); sqlForm.insert( surnameDisplay, "surname" ); sqlForm.insert( salaryEdit, "salary" ); sqlForm.readFields(); }
int main( int argc, char *argv[] ) { QApplication app( argc, argv ); if ( createConnections() ) { QSqlCursor staffCursor( "staff" ); QDataTable *staffTable = new QDataTable( &staffCursor ); app.setMainWidget( staffTable ); staffTable->addColumn( "forename", "Forename" ); staffTable->addColumn( "surname", "Surname" ); staffTable->addColumn( "salary", "Annual Salary" ); QStringList order = QStringList() << "surname" << "forename"; staffTable->setSort( order ); staffTable->refresh(); staffTable->show(); return app.exec(); } return 1; }
int main( int argc, char *argv[] ) { QApplication app( argc, argv ); if ( createConnections() ) { QSqlCursor staffCursor( "staff" ); QDataTable *staffTable = new QDataTable( &staffCursor ); QSqlPropertyMap *propMap = new QSqlPropertyMap(); CustomSqlEditorFactory *editorFactory = new CustomSqlEditorFactory(); propMap->insert( "StatusPicker", "statusid" ); staffTable->installPropertyMap( propMap ); staffTable->installEditorFactory( editorFactory ); app.setMainWidget( staffTable ); staffTable->addColumn( "forename", "Forename" ); staffTable->addColumn( "surname", "Surname" ); staffTable->addColumn( "salary", "Annual Salary" ); staffTable->addColumn( "statusid", "Status" ); QStringList order = QStringList() << "surname" << "forename"; staffTable->setSort( order ); staffTable->refresh(); staffTable->show(); return app.exec(); } return 1; }