Creating children in QtreeWidget with SQL data

[sam123]

Hello
I have two tables in SQL database and 1st table I have created as a parent In QtreeWidgit using QtreeWidgetItems now I have to add children in parents items respectly, here is the example

table1

Name

1. Marcus
2. Andreas
3. Jacop

table 2

Column 1
Devices

1. Laptop
2. Cell Phon
3. Pc
4. Laptop
5. PC
6. Cell Phon

Column 2
Name

1. Marcus
2. Marcus
3. Marcus
4. Andreas
5. Andreas
6. Jacop

Here table 1 is my parent items and table 2 has two column first is my children items and second I have given for the reference.
Now I have added parent in my QtreeWidget using QtreeWidgetItem but I am not able to add children saperatly.

Main problem I am getting is, Wheneever I add children, All children were added In each parent .

Looking for your advise
Thanks in advance.

[anda_skoa]

Looks like you forgot to post the code you are using for adding the child items.

Cheers,
_

[sam123]

Here is the code,

QList<QTreeWidgetItem*>item_list;
 
QSqlQuery query;
query.prepare("select Name from table1 ");
query.exec();
while(query.next())
{
     QTreeWidgetItem * tree_item = new QTreeWidgetItem();
     tree_item->setText(0,query.value(0).toString());
     item_list.append(tree_item);
     ui->treeWidget->addTopLevelItems(item_list);   // Adding Tablel 1 as a parents
 
     query.prepare("select Device from table2");
     query.exce();
     while(query.next())
     {
        QTreeWidgetItem * child_item = new QTreeWidgetItem();
        child_item->setText(0,query.value(0).toString());
        item_list.append(child_item);
        tree_item->addTopLevelItems(item_list);         // Adding Childen accourding to parents referance(not working)
                                                                          // every chid being adding in every parents.
     }
}

QList<QTreeWidgetItem*>item_list;

QSqlQuery query;
query.prepare("select Name from table1 ");
query.exec();
while(query.next())
{
     QTreeWidgetItem * tree_item = new QTreeWidgetItem();
     tree_item->setText(0,query.value(0).toString());
     item_list.append(tree_item);
     ui->treeWidget->addTopLevelItems(item_list);   // Adding Tablel 1 as a parents

     query.prepare("select Device from table2");
     query.exce();
     while(query.next())
     {
        QTreeWidgetItem * child_item = new QTreeWidgetItem();
        child_item->setText(0,query.value(0).toString());
        item_list.append(child_item);
        tree_item->addTopLevelItems(item_list);         // Adding Childen accourding to parents referance(not working)
                                                                          // every chid being adding in every parents.
     }
}

To copy to clipboard, switch view to plain text mode 

My Output:

1. Marcus
   
   1. Laptop
   2. Cell Phon
   3. PC
   4. Laptop
   5. PC
   6. Cell Phone
2. Andreas
   
   1. Laptop
   2. Cell Phon
   3. PC
   4. Laptop
   5. PC
   6. Cell Phone
3. Jacop
   
   1. Laptop
   2. Cell Phon
   3. PC
   4. Laptop
   5. PC
   6. Cell Phone

Expected Output:

1. Marcus
   
   1. Laptop
   2. Cell Phon
   3. PC
2. Andreas
   
   1. Laptop
   2. PC
3. Jacop
   
   1. Cell Phone
   
   

[anda_skoa]

item_list is defined out side of the loop, so the same instance is used in each loop iteration.
You are adding the same list without ever clearing it.

Just don't use that list, you don't need it.

Cheers,
_