read sqlite to array

hello everyones
i have a question which need help,
i have creat a database in qsqlite with 4 column and 100 rows,
after i use qtableview to display this database
how i can read all column of qtableview to array with 100 rows element for array
or how i can read all items in sqlite to array above
thank

From the table view you can get the data using its model, accessible through the model() method.
From the database you can use QSqlQuery

Cheers,
_

hi you
i am a newbie ,therefore i still dont know, you can demo it
can you help me to get all items from qtableview(4 rows ,4 columns) to string
thank

Lets assume you take the first approach

You get the model

Code:

---

QAbstractItemModel *model = tableView->model();

---

To get the number of rows use QAbstractItemModel::rowCount()

Code:

---

const int rowCount = model->rowCount();

---

Now you loop over all rows.
For each row you either loop over the columns or address them specifically

Code:

---

QModelIndex index = model->index(currentRow, 0); // first column;

---

You get the displayed text of a cell from the QModelIndex

Code:

---

QString text = index.data(Qt::DisplayRole).toString();

---

Cheers,
_