self-referencing hierarchical table not displaying

State Not Answered
Replies 10 replies
Subscribers 11 subscribers
Views 1813049 views
Users 0 members are here

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>

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
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 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
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
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