tableView Problem

[hrcariaga]

Is there anybody here can help me view my records in MySQL to the tableView?

thanks....

[hrcariaga]

Please help....

I'm new to Qt and I don't know much of the functions yet..

Heres my problem, I trying to view my records from MySQL to the tableView, but I haven't find a right code.

Please give me a simple code to this.


thanks...

[miguel_mark]

use this...

model = new QSqlTableModel(this);
model->setTable(trainingname);//trainingname-name of table to be viewed
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
 
model->setHeaderData(0, Qt::Horizontal, tr("CERTIFICATES"));
model->setHeaderData(1, Qt::Horizontal, tr("CERTIFICATE NO."));
model->setHeaderData(2, Qt::Horizontal, tr("TRAINING CENTER"));
model->setHeaderData(3, Qt::Horizontal, tr("DATE"));
model->sort(0, Qt::AscendingOrder);
view = new QTableView;
view->setModel(model);

model = new QSqlTableModel(this);
model->setTable(trainingname);//trainingname-name of table to be viewed
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();

model->setHeaderData(0, Qt::Horizontal, tr("CERTIFICATES"));
model->setHeaderData(1, Qt::Horizontal, tr("CERTIFICATE NO."));
model->setHeaderData(2, Qt::Horizontal, tr("TRAINING CENTER"));
model->setHeaderData(3, Qt::Horizontal, tr("DATE"));
model->sort(0, Qt::AscendingOrder);
view = new QTableView;
view->setModel(model);

To copy to clipboard, switch view to plain text mode 

[hrcariaga]

thanks, i finally made it...

[hrcariaga]

I have added a tableView widget in my interface using the designer.

The problem is, I can't find a right code to view my records in it. I'm using MySQL database. Please help...

tnx...

[jpn]

What did you try so far? I thought you already made it.