WPF : How to Fill TreeView from DataBase

Question

1.57/5 (6 votes)

See more:

hi ,

i have this table name is Job_Type_tab

id father Name
1 NULL A
2 NULL B
3 2 C
4 1 D
5 4 E
6 4 F
7 3 G
8 1 H

and i want fill this table in treeview

the tree must be fill like this
A
-D
--F
--E
-H
B
-C
--G

iwrite this code but this not good

private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            var g = from h in Context.Job_Type_tab
                    where h.father == null
                    select h;
            List<Job_Type_tab> j = g.ToList<Job_Type_tab>();
            for (int i = 0; i < j.Count; i++ )
            {
                TreeViewItem treefather = new TreeViewItem();
                treefather.Header = j[i].Name;
                treebig.Items.Add(treefather);
                Int64 id = j[i].job_type_id;
                ScanChiled(id,treefather);
                
            }
        }

        public void ScanChiled(Int64 father,TreeViewItem treefather)
        {
            if (father == null)
                return;
            TreeViewItem treeChiled = new TreeViewItem();
            var c = from h in DLandS.Program.Context.Job_Type_tab
                    where h.father == father
                    select h;
            List<DLandS.Job_Type_tab> j = c.ToList<DLandS.Job_Type_tab>();
            for (int i = 0; i < j.Count; i++)
            {
                TreeViewItem tree = new TreeViewItem();
                treefather.Header = j[i].Name;
                treeChiled.Items.Add(tree);
                Int64 id = j[i].job_type_id;
                ScanChiled(id ,tree);
                
            }
            treefather.Items.Add(treeChiled);
        }

help me.........

Posted 27-Jun-11 20:56pm

Noze

Add a Solution

Comments

Sergey Alexandrovich Kryukov 28-Jun-11 3:12am

No idea: what's the problem?
--SA

Noze 28-Jun-11 5:45am

t want code to fill this grid becase this code false

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Pete O'Hanlon · Answer 1 · 2011-06-27T23:10:00

This is much easier to achieve if you use the databinding features of WPF. If I was writing this, I'd create a class that represented the hierarchy of data that you want to display - this would be bound to from the XAML. I would write the class to look something like this:

C#

public class JobType
{
  public JobType()
  {
    JobTypes = new ObservableCollection<JobType>();
  }
  public ObservableCollection<JobType> JobTypes { get; set; }
  public string Name { get; set; }
}

Next, I'd add a reference to this class in my view model like this:

C#

public ObservableCollection<JobType> JobTypes { get; set; }

We are going to bind the treeview to this top level item, and use a HierarchicalDataTemplate to bind to the JobTypes entry in each instance of JobType.

C#

<TreeView ItemsSource="{Binding JobTypes}">
  <TreeView.ItemTemplate>
    <HierarchicalDataTemplate ItemsSource="{Binding JobTypes}" DataType="{x:Type local:JobType}">
      <StackPanel Orientation="Horizontal">
        <TextBlock Text="{Binding Name}" />
      </StackPanel>
    </HierarchicalDataTemplate>
  </TreeView.ItemTemplate>
</TreeView>

Make sure that you add a reference to your XAML to the namespace that contains the JobType class (I've called it local in the DataType markup).