load data from database to tree view

Nevez

This post is deleted!

Nevez

can anyone help ?

Christian Ehrlicher

@Nevez said in load data from database to tree view:

can anyone help ?

Why so impatient?
The treeview you show above is not that easy. You have to build your tree model by your own.

Nevez

@Christian-Ehrlicher I know that too. However, I have no idea how to do this. Can you give some hint

JonB

@Nevez
To create a hierarchical parent-child tree model you need two things from your data:

Some unique id column for every row.
A parent_id column in every row, whose value is the unique id of some other row which is its parent.

You could store these as columns in your actual database TABLEs, or via VIEWs you create on the tables, or via your SELECT statement, as suitable. You can also impose a suitable QAbstractProxyModel on top of your SQL model to present the data hierarchically to the QTreeView.

Then you have the information to populate your data model/table view correspondingly.

I have not looked through it, but starting from Googling, say, qt qsqldatabase qtreeview, there is
https://stackoverflow.com/questions/53418180/populate-qtreeview-as-parent-and-child-nodes-from-database
https://forum.qt.io/topic/83982/populate-qtreeview-from-sql
https://www.qtcentre.org/threads/23698-how-to-display-QSqlQueryModel-in-QTreeView

Nevez

Thanks for your interest, I'll look into them :)