Linq to XML Read and output XML generated from lookup list
- by Greg S
I am trying to use XML created from a lookup list in SharePoint as a datasource for a treeview. It is in the form of :
<NewDataSet>
<test_data>
<ID>1</ID>
<Title>MenuItem_1</Title>
<child_of />
</test_data>
<test_data>
<ID>2</ID>
<Title>Subitem_1</Title>
<Action>http://www.google.com</Action>
<child_of>MenuItem_1</child_of>
</test_data>
<test_data>
<ID>3</ID>
<Title>Subitem_2</Title>
<Action>http://www.google.com</Action>
<child_of>MenuItem_1</child_of>
</test_data>
<test_data>
<ID>4</ID>
<Title>MenuItem_2</Title>
<child_of />
</test_data>
<test_data>
<ID>5</ID>
<Title>Subitem_2_1</Title>
<Action>http://www.google.com</Action>
<child_of>MenuItem_2</child_of>
</test_data>
<test_data>
<ID>6</ID>
<Title>Subitem_2_2</Title>
<Action>http://www.google.com</Action>
<child_of>MenuItem_2</child_of>
</test_data>
<test_data>
<ID>7</ID>
<Title>Subitem_2_2_1</Title>
<Action>http://www.google.com</Action>
<child_of>Subitem_2_2</child_of>
</test_data>
</NewDataSet>
There may be N tiers, but the items relate to the parent via the <child_of> element.
I can't seem to figure out how to write the LINQ in C# to nest the menu items properly.
A friend recommended I post here. Any help is greatly appreciated.