show User Defined Header Labels in QTableView

[nagabathula]

I wanted to put the Header Names which i have defined on the Top Horizontal Header, instead of the horizontal header names which are column names of the sql table. . i have all the names which i want in a QStringList. i looked a lot but din find a solution. .. can any one pls tell me how to go about it.

[Lykurg]

setHorizontalHeaderLabels requires a QStringList, furthermore make sure you set the labels after the model is populated. And I guess you have to set the labels everytime you change the query.

EDIT: or make it, like the documentation tells:

QSqlQueryModel *model = new QSqlQueryModel;
     model->setQuery("SELECT name, salary FROM employee");
     model->setHeaderData(0, Qt::Horizontal, tr("Name"));
     model->setHeaderData(1, Qt::Horizontal, tr("Salary"));
 
     QTableView *view = new QTableView;
     view->setModel(model);
     view->show();

QSqlQueryModel *model = new QSqlQueryModel;
     model->setQuery("SELECT name, salary FROM employee");
     model->setHeaderData(0, Qt::Horizontal, tr("Name"));
     model->setHeaderData(1, Qt::Horizontal, tr("Salary"));

     QTableView *view = new QTableView;
     view->setModel(model);
     view->show();

To copy to clipboard, switch view to plain text mode 

[nagabathula]

Hello Lykurg your example helped me solve my problem.. This is what i did to display the Header Labels which i have defined.

for(int i=0; i<thermoNames.count(); i++)
 {
	 model->setHeaderData( i, Qt::Horizontal,thermoNames.at(i));
 }

for(int i=0; i<thermoNames.count(); i++)
 {
	 model->setHeaderData( i, Qt::Horizontal,thermoNames.at(i));
 }

To copy to clipboard, switch view to plain text mode 

thank you