How to save the content from a QTreeWidget (tree structure, model) to database

[whitefurrows]

Hi,

sorry for my bad english, but i have understand the concept of relational databases. I have start my first try to create a tree structure. It looks good but only one problem exist. The tree should look like this:


but that is the result



from this table



The tree was build with this function

addTree(0);
 
void MyWidget::addTree(const int id)
{
    QList<Entries*> folders = db->getEntries(id);
    MyTreeWidgetItem* item;
 
    foreach(Entries* obj, folders)
    {
        if(obj->getParentID())
        {
            item=new MyTreeWidgetItem(treeWidget->currentItem());
        }
        else
        {
            item=new MyTreeWidgetItem(treeWidget);
        }
 
        item->setEntries(obj);
        item->setText(0, obj->getName());
        item->setIcon(0, QIcon(":/folder.ico") );
        treeWidget->setCurrentItem(item);
 
        addNodes(obj->getID());
    }
}

addTree(0);

void MyWidget::addTree(const int id)
{
    QList<Entries*> folders = db->getEntries(id);
    MyTreeWidgetItem* item;

    foreach(Entries* obj, folders)
    {
        if(obj->getParentID())
        {
            item=new MyTreeWidgetItem(treeWidget->currentItem());
        }
        else
        {
            item=new MyTreeWidgetItem(treeWidget);
        }

        item->setEntries(obj);
        item->setText(0, obj->getName());
        item->setIcon(0, QIcon(":/folder.ico") );
        treeWidget->setCurrentItem(item);

        addNodes(obj->getID());
    }
}

To copy to clipboard, switch view to plain text mode 

I think the problem is i set every time the current item to the QTreeWidget. I don't known what the right criteria to do that. Can you help me please?