Treeview style Radgrid...

[Joss Markham]

Hello,

I have an xml document such as this:

<Message>
    <SequenceNumber>1</SequenceNumber>
    <Comments>
        <Comment>
            <SequenceNumber>1</SequenceNumber>
            <CommentSource>REMOTE_HOST</CommentSource>
            <CommentText>Free text comment data</CommentText>
            <CommentType>FT</CommentType>
        </Comment>
        <Comment>
            <SequenceNumber>2</SequenceNumber>
            <CommentSource>REMOTE_SOURCE</CommentSource>
            <CommentText>Free text comment data</CommentText>
            <CommentType>FT</CommentType>
        </Comment>
    </Comments>
    <DelimiterDefinition>|\^~</DelimiterDefinition>
    <SenderID>REMOTE_HOST</SenderID>
    <ReceiverID>LOCAL_HOST</ReceiverID>
    <Comment>EmptyComment</Comment>
    <ProcessingID>Production</ProcessingID>
    <Version>1</Version>
    <DateTime>0001-01-01 00:00:00</DateTime>
    <CustomerIdentifying>
        <CustomerIdentifyingRecord>
            <SequenceNumber>1</SequenceNumber>
            <Comments>
                <Comment>
                    <SequenceNumber>1</SequenceNumber>
                    <CommentSource>REMOTE_SOURCE</CommentSource>
                    <CommentText>Free text comment data</CommentText>
                    <CommentType>FT</CommentType>
                </Comment>
            </Comments>
            <Name>Jones^David</Name>
            <MothersMaidenName />
            <BirthDate>1964-03-15</BirthDate>
            <Sex>M</Sex>
            <EthnicOrigin>NotSpecified</EthnicOrigin>
            <Address />
            <TelephoneNumber />
            <TestOrder>
                <TestOrderRecord>
                    <SequenceNumber>1</SequenceNumber>
                    <Comments />
                    <Priority>U</Priority>
                    <UserField1>Order Comments</UserField1>
                    <UserField2 />
                </TestOrderRecord>
            </TestOrder>
        </CustomerIdentifyingRecord>
    </CustomerIdentifying>
</Message>

Can I display this data in a hierarchical radgridview where child records/tables of "Message" can be both "Comment" tables and "CustomerIdentifyingRecord" tables?

Simply loading the xml as a dataset does not appear to be sufficient.

Is this possible with the radgridview?

Thanks

[Jack]

Hello Joss,

Thank you for contacting us.

Yes, this scenario is possible. There are two solutions:

1. You can load your data in a DataSet by using the ReadXml method.
2. You can load your data manually in some business objects that implement IList or IBindingList interfaces. In this case you should add your relation information in the RadGridView.Relations collection.

Currently it is not possible to show more than one table in one level in RadGridView. Nevertheless, this is a major feature and it is in our TODO list with high priority.

Please let me know if you have other questions.
 

Sincerely yours,
Jack
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Joss Markham]

Thanks for your reply.

I think that the 1st solution is the most suitable, and I have tried it serveral ways but without success.

However, if multiple child tables of 1 record are not possible, I should maybe find another approach.

Thanks again.

[Jack]

Hi Joss,

I would suggest as an alternative solution to use a flat grid and a tab strip containing separate grid controls. In this case you should change the DataSource manually when the current row in the master grid is changed. This can be done by processing the CurrentRowChanged event.

If you are interested, I could inform you when we have a strict time line when this feature will be implemented.

Do not hesitate to contact me if you have any other questions.

All the best,
Jack
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center