tree view data bind to dropdown selection index

Question

4.00/5 (2 votes)

See more:

I AM CREATING AN EXAMPLE in c# using SQL WHERE I HAVE TO SHOW THE COMPANY NAME WITH "PARENTID" , "0" IN COMBO BOX AND ITS PRODUCTS AND SUB PRODUCTS IN THE TREE VIEW CONTROL Based on THE COMBO BOX SELECTION.

THE FORMAT OF MY TABLE IN SQLTABLE IS

ID          NAME                PARENTID
1           DELL                  0
2           IBM                   0
1.1         COMPUTER              1
1.2         PRINTER               1
1.1.1       RAM                   1.1

SO IF I SELECT "DELL" in the combobox

I SHOULD BE ABLE TO SEE

"THE COMPUTER AND PRINTER"

AND ON FURTHER EXPANSION OF tree control

"RAM"

and ALL THIS IS STORED IN ARRAY COLLECTION VARIABLE. NEED HELP?

Posted 6-Feb-12 4:52am

notoriousdevil

Add a Solution

Comments

BillWoodruff 7-Feb-12 22:31pm

I would certainly start by examining the possibility of binding the TreeView contents to your data: and then consider ... assuming the SQL Tables need transformation into another form ... to be usable for data-binding to the TreeView ... what's required for that transformation.

Start by searching here on CP and StackOverFlow on "treeview" and "data binding."

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)

Mohamed Ahmed Abdullah · Answer 1 · 2012-02-09T20:33:00

it will be some thing like that

C#

var fathers = GetParents().ToList();

getParents to get all the records that have 0 in it's parent Id. then

C#

foreach (var f in fathers)
{
    _cachedFathers.Add(f);
    MyChilds(f);
}

C#

private void MyChilds(Company comp)
{
    tvi.Children = new ObservableCollection<JobDto>();
    var childs = GetParents(tvi.CompanyId).ToList();
    foreach (var c in childs)
    {
        comp.Children.Add(c);
    }
}

GetParents(int companyId) shold give you all the companies that have "companyId" in the ParentId column

and in the Company Calsss you should have

XML

public Company Parent { get; set; }

private ObservableCollection<Company> _children = new ObservableCollection<Company>();
public ObservableCollection<Company> Children
{
    get { return _children; }
    set { _children = value; OnPropertyChanged("Children"); }
}

that will give you an object fathers full of hierarchy data

Hope this help