XDocument getting Root Attributes values

Question

How can I get the value of title1 from this string in a datatable using xDocument

<Person ActionType = "Update"  Title1="Miss" />

I tried descendants, XAttributes and all sorts...Maybe input is wrong but

XDocument xml = XDocument.Parse(row["XMLTransaction"].ToString());

IEnumerable<XAttribute> query =
from transaction in xml.Root.Elements()
select transaction.Attribute(attribute);

score 1 · Accepted Answer · answered Apr 11 '12 at 08:33

1

If that string is your literal XML then you should omit the .Elements() part.

Even shorter with XElement instead of XDocument :

 var xml = XElement.Parse(row["XMLTransaction"].ToString());

 IEnumerable<XAttribute> query = xml.Attributes();

answered Apr 11 '12 at 08:33

H H

263,252
30
330
514

Well that did it thanks. Just wish there was some website tutorial - maybe i need to improve my googling – insanepaul Apr 11 '12 at 08:46
By the way, how do I get the value? I've been trying all morning – insanepaul Apr 11 '12 at 10:19
`query2 = xml.Attributes().Select(a => a.Value);` gives an `IEnum` – H H Apr 11 '12 at 10:30
xattributes do not contain a definition for 'Select'. i can iterate through them using foreach but wondered best way of accessing the value of the attribute – insanepaul Apr 11 '12 at 10:40
It's an extension method, you need `using System.Linq;` – H H Apr 11 '12 at 12:44

XDocument getting Root Attributes values

1 Answers1