Hierarchical XML Data into a radGrid?

[Peter]

Hi,

I have the following XML:

<foo>
  <bar>
    <abc label="bar: 1"><![CDATA[Guiness]]></abc>
    <def>1234</def>
  </bar>
  <bar>
    <abc label="bar: 2"><![CDATA[Heineken]]></bar>
    <def>4567</def>
  </bar>
  ...
</foo>

This XML is loaded into a datasource using an XPath expression:

myXML.XPath = "/foo";

I now would like to use a radGrid to store all the info of the child-nodes of bar. In the example XML above, this would be the abc and def nodes, though the actual amount of them might differ. I'd like to have the individual child nodes of the bars displayed as columns.

So the desired outcome would be a grid displaying:

bar..........abc..........def
1............Guiness...1234
2............Heineken..4567

I tried directly binding to the XML, and played around with different XPAth statements trying to get things to work, but ended up with an error: Cannot find any bindable properties

Any ideas?

Thanks in advance!

Peter

[Antonio Stoilkov]

Hi Peter,

I have assembled a sample project demonstrating the desired functionality implemented. Note that in order to bind the RadGrid each column representation is an attribute not an individual element as it is shown below. 

<?xml version="1.0" encoding="utf-8" ?>

<foo>
  <bar abcLabel="bar: 1" def="1234">
  </bar>
  <bar abcLabel="bar: 2" def="2345">
  </bar>
</foo>

<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/App_Data/Data.xml"
    XPath="foo/bar"></asp:XmlDataSource>

Additionally, you could go through the code library below describing how you could implement your scenario using different approach.

• Binding RadGrid programmatically to hierarchical XML data

Regards,
Antonio Stoilkov
the Telerik team