self-referencing hierarchical table not displaying

kayle posted over 16 years ago

Hello,

I have a table with an AccountID column and a ParentID column. There is a data relation, Children, that relates the columns. Below is the xaml I have written to try and get it to work, but when I add the <igDP:Field Name="Children" /> field, only the second FieldLayout is displayed, and the first FieldLayout disappears. What do I need to change to get this to work? Does the hierarchical stuff only work with multiple tables?

            <igDP:XamDataGrid.FieldLayouts>
                <igDP:FieldLayout>
                    <igDP:FieldLayout.Fields>
                        <igDP:Field Name="Name" />
                        <igDP:Field Name="Type" />
                        <igDP:UnboundField Name="Balance" DataType="system:Decimal"/>
                        <igDP:Field Name="Inactive" Visibility="Collapsed" />
                        <igDP:Field Name="Children" />
                    </igDP:FieldLayout.Fields>
                </igDP:FieldLayout>
                <igDP:FieldLayout>
                    <igDP:FieldLayout.Fields>
                        <igDP:Field Name="Name" />
                        <igDP:Field Name="Description" />
                    </igDP:FieldLayout.Fields>
                </igDP:FieldLayout>

Parents

95

Nasir posted over 16 years ago
I have a similar issue... but a variation of it ...

Here is what I have:

A self-referencing Table with Parent Child Relationship:

TABLE: ParentId, AccountId, AccountName

Accounts hierarchy can be as deep as 10 down... or infinite.....

Have data available in DataSet or XML format both

Here is what I want: Simple, but oh well don't get me started:

I want a xamDataGrid to show proper hierarchy based on my model, hopeful not with too much of convoluted code in XAML or c#

I DO NOT want to see headers anywhere in the xamDataGrid

I want to see + or arrow buttons where the accounts have sub accounts and NOT where there aren't any more. The last node should not have any plus sign

The only visible field is the account name, IDs are hidden or collapsed

I want AccountId returned to me when I click the AccountName node

And yes, it has to be a TreeView style ofcourse...

Ok, show me the easiest and fastest way there....

Thanks
Cancel
Reply

Cancel
95

Nasir posted over 16 years ago in reply to Nasir

Thank you for NO support. As of Friday we have chosen to dump Infragistics WPF controls and have adopted a different product.

Cheers....
Cancel
Reply

Cancel
1230

Robert posted over 15 years ago in reply to Nasir

We have accomplished this with the system we are currently building. I have been able to use the XamDataGrid to mimic a tree view using a single, self referencing table of Parent-Child relationships to an Nth level of Parent - Child relationships.

However there is no magic and it did take lots of C# code, XAML, and SQL to accomplish. If someone is still interested I might be able to help.

Cheers.....
Cancel
Reply

Cancel
69686

John Doe posted over 15 years ago in reply to Robert

Hello,
I attached an example of binding the xamDataGrid with DataSet and LINQ with self-relation.

WpfApplication1.zip
Cancel
Reply

Cancel
1230

Robert posted over 15 years ago in reply to John Doe

I have a model that works for me. I also am willing to share. I am not using Datasets but the actual Business Objects themselves.

I guess I was irked by the guys e-mail. Build my app for me, fast and easy, and I will buy your products. There is always a way to do something and but it is not always "fast and easy". Sometime there is not a sample to copy and you actually have to think and develop a model of your own.

Imagine, a developer actaully developing instead of copying the sample.
Cancel
Reply

Cancel

Reply

275

Joe Gilkey posted over 15 years ago in reply to Robert

I would like to see your sample if possible, and I am sure there are lots of other people that would like to see too.

Thanks,

Joe
Cancel
Reply

Cancel

Children

1230

Robert posted over 15 years ago in reply to Joe Gilkey

I would share but it is complicated and relies on a SQL Recursive CTE to generate the initial hierarchical structure. The hierarchy structure uses ParentID, WbsLevel, WbsSequence fields to create a grid record key that can be used as the sort column in the XamDataGrid to keep it in hierarchical sequnece. Also a custom "ExpandGridrowButton" that Curtis from Infragistics helped me create to show or hide child gridrows based on HasChildren and RecVisible fields to get functionality similar to a tree view. Also functionality to create children, parents, move units and children withn the hierarchy.

To create a sample I can send as a project would be a project in itself. Currently I am under a deadline to get version 1 of the system developed by March 31 and cannot spend time creating a portable sample. I am sorry if this is a lame excuse but right now it is a reality for me. I have done a lot of work on this to de-bug and it is possible that by May I would have time to create a portable sample that worked off a dataset.
Cancel
Reply

Cancel