QTableView and MySQL

[fnmblot]

Could someone point me to an example of how to populate a QTableView widget created with designer, getting its rows from a MySQL database? Would I just do something like:

QSqlQueryModel *tvdsModel = new QSqlQueryModel;
tvdsModel->setQuery("SELECT blah FROM main");
 
ui.tvdsView->setModel(tvdsModel);

QSqlQueryModel *tvdsModel = new QSqlQueryModel;
tvdsModel->setQuery("SELECT blah FROM main");

ui.tvdsView->setModel(tvdsModel);

To copy to clipboard, switch view to plain text mode 

[fnmblot]

I guess all I had to do was think about it and try it before I posted. If it is any consolation, here is what I did:

//testTable.cpp
#include "tableTest.h"
#include <QtSql>
//
TableTestDlg::TableTestDlg( QWidget * parent, Qt::WFlags f) 
	: QDialog(parent, f)
{
	tableViewUi.setupUi(this);
 
	QSqlQueryModel *tableViewModel = new QSqlQueryModel;
	tableViewModel->setQuery("SELECT piece_name, nn, status FROM main WHERE nn !='0' ORDER BY uid");
 
	tableViewModel->setHeaderData(0, Qt::Horizontal, "Piece Name");
	tableViewModel->setHeaderData(1, Qt::Horizontal, "NN");
	tableViewModel->setHeaderData(2, Qt::Horizontal, "Status");
 
	tableViewUi.tableView->setModel(tableViewModel);
	tableViewUi.tableView->resizeColumnsToContents();
	tableViewUi.tableView->setAlternatingRowColors(true);
}
TableTestDlg::~TableTestDlg()
{}

//testTable.cpp
#include "tableTest.h"
#include <QtSql>
//
TableTestDlg::TableTestDlg( QWidget * parent, Qt::WFlags f) 
	: QDialog(parent, f)
{
	tableViewUi.setupUi(this);
	
	QSqlQueryModel *tableViewModel = new QSqlQueryModel;
	tableViewModel->setQuery("SELECT piece_name, nn, status FROM main WHERE nn !='0' ORDER BY uid");

	tableViewModel->setHeaderData(0, Qt::Horizontal, "Piece Name");
	tableViewModel->setHeaderData(1, Qt::Horizontal, "NN");
	tableViewModel->setHeaderData(2, Qt::Horizontal, "Status");

	tableViewUi.tableView->setModel(tableViewModel);
	tableViewUi.tableView->resizeColumnsToContents();
	tableViewUi.tableView->setAlternatingRowColors(true);
}
TableTestDlg::~TableTestDlg()
{}

To copy to clipboard, switch view to plain text mode 

[jpn]

I guess all I had to do was think about it and try it before I posted.

It's always a good idea. Also, notice that a bunch of SQL examples is shipped with Qt.

[KnumSoft]

Hey fnmblot:

You probably have forgotten about this post, but I would like to thank you for your original question, AND the courtesy of following up with the solution you came up with. This is very helpful to others (like me).