[Solved] How to set color to a tableview values from the database

[A Former User]

@ Log cnn;
QSqlQueryModel *modal=new QSqlQueryModel();
QSqlQuery *qry=new QSqlQuery(cnn.mydb);
qry->prepare("select *from AccessLog");
qry->exec();
modal->setQuery(*qry);
ui->tableView->setModel(modal);
qDebug()<<(modal->rowCount());
@
With this method i can set a QSQlQueryModels to my QTableviews.How i can set color to each row in tableview.

[clochydd]

To achieve alternating colours for the rows you may set

@
ui->tableView->setAlternatingRowColors(true);
@

then set the colours of Base and AlternateBase in the palette.

[A Former User]

Thanks.....

[Eddy]

Does that mean that you figured out the problem? If so, Please add [solved] to the topic so everyone can see that this problem is solved. You can do that by editing your first post.

[A Former User]

And also one method for this solution,In QtCreator UI Forms select the tablview control and change the property of styleSheet. It include the various options such as color,background color,border color etc.