Hi!! I have a table that is related to itself by the field 'parentId' and the project is working under Hibernate. The table name is 'JobCode' and the jobs that have parentId = NULL are the parents that I want to display in level 1 nodes and for each parent I have some childs that I want to display as level 2 nodes. Does anybody know how to do this? Because I could display all parent nodes in the tree but I couldn't assign them its childs... Thx!

There is SQL to do this very thing. (I forget the key word(s), but it is there.)

The problem is not how to get the the data. The problem is how to display it in an UltraWinTree of Infragistics. I want to display de nodes with some columns. It would be something like this:

I have the class 'Tarea' that has the following attributes:
    Codigo as String
    Descripcion as String
    CodigoTareaPadre as Tarea
    TareasHijas as List(Of Tarea)
    TareasPrevias as List(Of TareasPrecedentes)

The class 'TareasPrecedentes' has two members:
    TareaPrevia as Tarea
    TareaPosterior as Tarea

I want to display in an UltraWinTree something like the following example:

(IN DATABASE)
Codigo Descripcion CodigoTareaPadre
--------------------------------------------------------
Tarea1 This is Tarea1 NULL
Tarea2 This is Tarea2 NULL
SubTarea1 This is SubTarea1 Tarea1
SubTarea2 This is SubTarea2 Tarea1
SubTaera3 This is SubTarea3 Tarea2

I want it to end up like this (with the OutlookExpress ViewStyle):

 ---------------------------------------
|Codigo | Descripcion |
 ---------------------------------------
+ Tarea1 This is Tarea1
    SubTarea1 This is SubTarea1
    SubTarea2 This is SubTarea2

+ Tarea2 This is Tarea2
    SubTarea3 This is SubTarea3

When I assign the datasource to the UltraWinTree, it displays the parent
nodes and for each one, two collections (one of TareasHijas and the other of
TareasPrevias). I just want to display the collection of TareasHijas with
the paramateres shown before.

This sounds more like a control related problem and, I don't think, any of us will be much help. why not contact Infragistics tech support? I am sure they will be able to help you.

"The one language all programmers understand is profanity."