How to display table from DB in TreeView WPF?

Question

SQL

There is a hierarchical table shown in the figure.

There is a connection to the database.
How to display this table in TreeView?
-Guitar
-----Acoustic
------------Classical
------------ 6-string(metal strings)
-----Bass
--- -------- Acoustic
------------ 4-string
----- Keyboard
------------ Synth
------- ----- midi keyboard

Answer 1

You need to create a class like this:

class Item
{
  public string Name {get;set;}
  public IEnumerable<Item> Children 
  {
    get {/* тут код получения из базы подчинённых элементов*/}
  }
}

Get a list of top-level items and assign the TreeView's ItemsSource.
In TreeView, in the description of the template for the element (ItemTemplate), describe the HierarchicalDataTemplate and specify the property for obtaining child elements in ItemsSource={Binding Children}.

<TreeView>
  <TreeView.ItemTemplate>
    <HierarchicalDataTemplate ItemsSource="{Binding Children}">
      <TextBlock Text="{Binding Name}" />
    </HierarchicalDataTemplate>
  </TreeView.ItemTemplate>
</TreeView>

Answer 2

Can we see your solution?