babygal
5th October 2010, 11:16
Here's the code i've written so far:
QSqlQueryModel *model;
QTableView *view;
model = new QSqlQueryModel;
view = new QTableView;
model->setQuery("SELECT s.scan_date,p.surname,p.first_name,p.nric_no,p.dob ,p.gender,r.description FROM PATIENT p,RACE r, SCAN_DATA s WHERE p.race = r.race AND p.patient_id=s.patient_id AND p.surname = '" + patientNamestr + "'");
model->setHeaderData(0, Qt::Horizontal, QObject::tr("Scan Date"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Surname"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("First name"));
model->setHeaderData(3, Qt::Horizontal, QObject::tr("NRIC"));
model->setHeaderData(4, Qt::Horizontal, QObject::tr("DOB"));
model->setHeaderData(5, Qt::Horizontal, QObject::tr("Gender"));
model->setHeaderData(6, Qt::Horizontal, QObject::tr("Race"));
view->setModel(model);
view->setSelectionBehavior(QAbstractItemView::SelectRows );
view->setSelectionMode(QAbstractItemView::SingleSelectio n);
view->show();
When a row is selected in the table view, i want to connect it to a slot.
How to do that? Thanks.
QSqlQueryModel *model;
QTableView *view;
model = new QSqlQueryModel;
view = new QTableView;
model->setQuery("SELECT s.scan_date,p.surname,p.first_name,p.nric_no,p.dob ,p.gender,r.description FROM PATIENT p,RACE r, SCAN_DATA s WHERE p.race = r.race AND p.patient_id=s.patient_id AND p.surname = '" + patientNamestr + "'");
model->setHeaderData(0, Qt::Horizontal, QObject::tr("Scan Date"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Surname"));
model->setHeaderData(2, Qt::Horizontal, QObject::tr("First name"));
model->setHeaderData(3, Qt::Horizontal, QObject::tr("NRIC"));
model->setHeaderData(4, Qt::Horizontal, QObject::tr("DOB"));
model->setHeaderData(5, Qt::Horizontal, QObject::tr("Gender"));
model->setHeaderData(6, Qt::Horizontal, QObject::tr("Race"));
view->setModel(model);
view->setSelectionBehavior(QAbstractItemView::SelectRows );
view->setSelectionMode(QAbstractItemView::SingleSelectio n);
view->show();
When a row is selected in the table view, i want to connect it to a slot.
How to do that? Thanks.