XElement attribute sorting
I have a XML file like that:
<Users>
<User>
<Adress Name="bbbb"/>
开发者_如何转开发 <Adress Name="aaaa" />
</User>
</Users>
I want to sort User
element's nodes in ascending order. How can I order Adress
elements?
Thank you for your help.
If node is your user node:
node.Elements("Adress").OrderBy(e=>e.Attribute("Name").Value)
Are you merely wanting to work with the XML objects in memory or are you looking to store the sorted results back in a file?
This code shows reordering the elements within an XDocument so that you can save it.
string xml = @"<Users>
<User>
<Address Name=""bbbb""/>
<Address Name=""aaaa"" />
</User>
<User>
<Address Name=""dddd""/>
<Address Name=""cccc"" />
</User>
</Users> ";
XDocument document = XDocument.Parse(xml);
var users = document.Root.Elements("User");
foreach (var user in users)
{
var elements = user.Elements("Address").OrderBy(a => a.Attribute("Name").Value).ToArray();
user.Elements().Remove();
user.Add(elements);
}
If you want an ordered in-memory model, then you can do it like this
var query = from user in document.Root.Elements("User")
select new
{
Addresses = from address in user.Elements("Address")
orderby address.Attribute("Name").Value
select new
{
Name = address.Attribute("Name").Value
}
};
foreach (var user in query)
{
foreach (var address in user.Addresses)
{
// do something with address.Name
}
}
精彩评论