Nested list of people

Question

0.00/5 (No votes)

See more:

Hi all.

So I have a data structure like this:

ID---Name---Children
1----Toto------Child 1 Titi
---------------Child 2 Tata

2----Mimi------Child 1 Miti
---------------Child 2 Mata
---------------Child 3 Molo
3----Sasa---0

ID and name come from 1 table, children come from another table based on ID

I want to represent this as a list in c# like this

C#

<list item="" 1=""> 1, Toto, children {Titi, Tata}
<list item="" 2=""> 2, Mimi, children {Miti, Mata, Molo}
<list item="" 3=""> 2, Sasa, children {}

C#

public static class ListX
        {
            public static List<list<string>> GetListFromDB(string id)
            {
                List<list<string>> ListOfPeople = new List<list<string>>();
               //method that returns all items from DB and populates
               return ListOfPeople;
            }
        }

My problem is how do I define this list properly and then add items to the list?
I don't know how to add the children array.

What I have tried:

multiple arrays and returning them from 2 different methods.

Posted 24-Jan-21 20:25pm

clbogdan

Updated 24-Jan-21 21:15pm

RickZeeland

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2021-01-24T20:53:00

We can't give you an "exact" answer as we have no idea what your source data structure is or how it is organised.
But to populate your list you'd need more than just a List<list<string>> as your data holds more than just a list of children - it's needs an ID, each child needs an ID, and you add a count to it.

I'd create a Person class, something like this:

C#

public class Person
    {
    public int ID { get; set; }
    public string Name { get; set; }
    public List<Person> Children { get; set; } = new List<Person>();
    }

and then populate it from your data source, the equivalent of something like this:

C#

List<Person> all = new List<Person>();
Person parent = new Person() { ID = 1, Name = "Toto" };
all.Add(parent);
parent.Children.Add(new Person() { ID = 4, Name = "Titi" });
parent.Children.Add(new Person() { ID = 5, Name = "Tata" });
parent = new Person() { ID = 2, Name = "Mimi" };
all.Add(parent);
...

Only using your data source to get the information.

Nested list of people

1 solution

Solution 1

Add your solution here

Preview 0

Nested list of people

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us