show User Defined Header Labels in QTableView

[nagabathula]

Hello every one i have a QTableView in which i am displaying data from the sql database.. I am stuck at a small problem i wanted to display Header names for all the channel's which i have appended in a QStringList. I tried many things but i get the database table column name's as the header's.

QSqlQueryModel *model = new QSqlQueryModel(tableView);
model->setQuery("SELECT "+ colNames +" from thdata where rowid = (select max(rowid) from thdata)");
	tableView->setModel(model);
	tableView->showMaximized();	
	tableView->setAlternatingRowColors(true);
 
     //tableView->setHorizontalHeader(thermoNames);
     //tableView->setHorizontalHeaderLabels(QString(thermoNames));	
 
	tableView->resizeRowsToContents();
    tableView->resizeColumnsToContents();
	timeinterval.clear();
	tableView->verticalHeader()->setVisible(false);
	colNames.clear();

QSqlQueryModel *model = new QSqlQueryModel(tableView);
model->setQuery("SELECT "+ colNames +" from thdata where rowid = (select max(rowid) from thdata)");
	tableView->setModel(model);
	tableView->showMaximized();	
	tableView->setAlternatingRowColors(true);
	
     //tableView->setHorizontalHeader(thermoNames);
     //tableView->setHorizontalHeaderLabels(QString(thermoNames));	

	tableView->resizeRowsToContents();
    tableView->resizeColumnsToContents();
	timeinterval.clear();
	tableView->verticalHeader()->setVisible(false);
	colNames.clear();

To copy to clipboard, switch view to plain text mode 

this is what i am doing to display all the channels data from the database table, but the header is the column names in the Table i wanted to display the header names which i have defines and stored in a QString thermoNames; , Pls help me out.

Thank you

[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