Reading all root node names in an XML document

Question

I'm sure all the pros out there would find this very trivial but I need a quick solution for this in C#

I'm retrieving an xml schema of a view in share point which looks like this:

<FieldRef Name="LinkTitle"/><FieldRef Name="Author0"/><FieldRef Name="ID"/>

I want to parse this and only retrieve the Name's of each root element in this schema. currently this is the code I'm working on , need some help with it

String fieldvals = view.ViewFields.SchemaXml.ToString();
XmlDocument reader = new XmlDocument(); ;
reader.LoadXml(fieldvals);
String xpath = "/";
var nodes = reader.SelectNodes(xpath);

foreach (XmlNode childrenNode in nodes)
{
    Console.WriteLine(childrenNode.SelectSingleNode("//field1").Value);
}

Apparently, when this piece of code executes, I get an exception saying that more than one root node is present which is true of course .. but I'm not able to figure out the correct code to access every root node and extract it's name!

Ideally XML should have only one root node. You can wrap it in root node and then read all children at level 1 <FieldRefs><FieldRef Name="LinkTitle"/><FieldRef Name="Author0"/><FieldRef Name="ID"/></FieldRefs> — Durgesh Chaudhary
– Durgesh Chaudhary, Commented May 5, 2014 at 9:00
I think the issue is that an XML document isn't allowed to have more than one root node. You need to wrap the FieldRef elements into an extra, surrounding element (e.e. FieldRefs). — Medo42
– Medo42, Commented May 5, 2014 at 9:00
Alright! Got it, Can wrap the nodes in a parent node. But, please can you show me the correct code that i can use to then access these nodes as the children of the parent node? I'd really appreciate it! — Aman Gupta
– Aman Gupta, Commented May 5, 2014 at 9:07
wrapped it up in a parent div called FieldRefs, however now I'm getting an new exception message saying that object reference is not set to an instance of an object — Aman Gupta
– Aman Gupta, Commented May 5, 2014 at 9:11

Victor Mukherjee · Accepted Answer · 2014-05-05 09:13:49Z

2

Wrap your xml fragment within a root node and then you can use linq to xml to retrieve a string array of those names like this:

var xml = XElement.Parse(xmlString);
var names=xml.Elements().Attributes(@"Name").Select(attrib => attrib.Value);

answered May 5, 2014 at 9:13

Victor Mukherjee

11.3k20 gold badges61 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Durgesh Chaudhary · Accepted Answer · 2014-05-05 09:08:29Z

0

You should wrap your xml in some root node as an XML can have only one Root Node as below :

<FieldRefs>
    <FieldRef Name="LinkTitle"/>
    <FieldRef Name="Author0"/>
    <FieldRef Name="ID"/>
</FieldRefs>

And then your code will execute fine.

String fieldvals = view.ViewFields.SchemaXml.ToString();
XmlDocument reader = new XmlDocument(); ;
reader.LoadXml(fieldvals);
String xpath = "/FieldRefs/FieldRef";
var nodes = reader.SelectNodes(xpath);

foreach (XmlNode childrenNode in nodes)
{
    /*Process here*/
}

answered May 5, 2014 at 9:08

Durgesh Chaudhary

1,0772 gold badges12 silver badges32 bronze badges

3 Comments

Aman Gupta Over a year ago

yes i did try.. but I got the error I mentioned above

Durgesh Chaudhary Over a year ago

In which statement are you getting an error and what is the error string

Durgesh Chaudhary Over a year ago

If you want Name to be printed place at /*Process here*/ Console.WriteLine(childrenNode.Attributes["Name"].Value);

Collectives™ on Stack Overflow

Reading all root node names in an XML document

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related