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;
}
