MySQL database table row value display in QTableView like below mentioned image

[highlander]

bawahaha... andre, well i am a newly joined kid in School of Qt :), I need real help to get this assignment done :( ...

[andre]

I suggest you go to your teacher for help then.

[highlander]

He himself told me to post it here :-D

[andre]

He's paid to help you, we are not.

[highlander]

Why so serious dear Andre.... thanks anyway

[andre]

Because you're not showing your own effort. The point of your excersise is for you to learn Qt. Just giving you ready-made solutions won't teach you anything at all.

[qxoz]

That's great that the interest to Qt grows and grows. And all will be happy to help (at least i am) when possible. Just newcomers need to be more attentive and keep the forum rules. In the first place to search for similar topics on the forum and then create new topics. And try harder to solve issues their own.

[highlander]

OK From a little research I got this url: "It shows the ListModel, I guess thats what I need right?":http://files.itslearning.com/data/764/2405/qt4/ch10lev1sec3.html. Can anyone provide examples for this ListModel?

[andre]

Why don't you take this step by step? Your first step would be to get the data from the database into something that you can show in a QListView. Qt happens to have a few suitable models for that already... They both have 'Sql' in their name.

I stand by my advice to ignore the radio button for the time being.

[highlander]

Hi Andre, I have completed the First step as you said, here is my code:

@#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QStandardItemModel>
#include <QListView>
#include <QSqlDatabase>
#include <QSqlQueryModel>
#include <QListView>

MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);
QListView *listView = new QListView(this);
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("users_in_feb");
db.setUserName("web_me");
db.setPassword("");
if(!db.open())
{
qDebug()<< "Failed";
qDebug()<< db.lastError();
}
else
{
model = new QSqlQueryModel(this);
model->setQuery("Select Name from new_joiners");
listView->setModel(model);
listView->setFixedSize(300,300); //width and height of QListView
}
}

MainWindow::~MainWindow()
{
db.close();
delete ui;
}

void MainWindow::changeEvent(QEvent *e)
{
QMainWindow::changeEvent(e);
switch (e->type()) {
case QEvent::LanguageChange:
ui->retranslateUi(this);
break;
default:
break;
}
}
@

And the output : !http://i46.tinypic.com/2ykywjm.jpg!

Now it seems dont need radio buttons, but I need to send selected Name to another window. Guide me thanks.

[andre]

Well, time to dive into using signals and slots then... QListView exposes a couple of interesting signals you might use.

[highlander]

Andre, I am not able to get what I need in that Signals, in my mind, my need is like: "When Next > button is clicked, it must check if a value is selected in QListView or left empty, if empty, show an alert MessageBox, else the selected value must be submitted to the next Window and shown in the QLineEdit field." Help me, thanks.

[andre]

No, that is not what you need. It is bad usability. Instead of letting the user click the Next button, the next button should be disabled as long as there isn't anything selected yet. If you want to react on a click on the button, then obviously you need to take a look at the signals provided by that button, not by the list view.

Note that it seems that you are trying to make a wizard. Why not use QWizard for that?

[highlander]

Hi Andre, ur right, but in QListView, automatically the first element is selected when app starts, what can I do?