树视图数据绑定到下拉选择索引 [英] tree view data bind to dropdown selection index

问题描述

我正在使用SQL在c#中创建一个示例，在此示例中，我必须在基于COMBO BOX选择的树视图控件中的COMBO BOX及其产品和子产品中显示"PARENTID"，"0"的公司名称. br/>

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

如果我在组合框中选择"DELL"，那么

我应该可以看到

计算机和打印机"

并进一步扩展树控件

"RAM"

并且所有这些都存储在ARRAY COLLECTION变量中.需要帮助吗?

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?

推荐答案

会是这样的事情

it will be some thing like that

var fathers = GetParents().ToList();

getParents获取其父ID中具有0的所有记录.然后

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

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

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)保留为您提供在ParentId列中具有"companyId"的所有公司.

并且在Calsss公司中您应该拥有

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

and in the Company Calsss you should have

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

这篇关于树视图数据绑定到下拉选择索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！