C# ASP.NET Sort XML Nodes by custom attribute

Question

Is there a way we can sort xmlnodes based on attribute values? The point is that every child node has a different name, despite it, I want to sort them by attribute.
E.g.

<Doc>
<mar_03 data="03">
  <Mattina_Turno_1 />
</mar_03>
<dom_01 data="01">
  <Mattina_Turno_1 />
</dom_01>
<mer_04 data="04">
  <Mattina_Turno_1 />
  <Mattina_Turno_2 />
</mer_04>
</Doc>

Should become

<Doc>
<dom_01 data="01">
  <Mattina_Turno_1 />
</dom_01>
<mar_03 data="03">
  <Mattina_Turno_1 />
</mar_03>
<mer_04 data="04">
  <Mattina_Turno_1 />
  <Mattina_Turno_2 />
</mer_04> </Doc>

How can I do it? After sorting obviously I want to overwrite the file.

This answer does not fix my problem since i can not define the node "item" since every my nodes are named differently.

Thanks, and please do not mark it as duplicate, because it is not!

Possible duplicate of How to sort XML files by a node attribute in C# — Feras Al Sous
– Feras Al Sous, Commented Sep 13, 2017 at 12:00
The following solution can not be applied here. @FerasAlSous — Jonathan I
– Jonathan I, Commented Sep 13, 2017 at 12:08

Vijayanath Viswanathan · Accepted Answer · 2017-09-13 13:09:28Z

1

Please try,

XDocument xdoc = XDocument.Load("File.xml");

        var result = xdoc.Element("Doc")
        .Elements()
        .OrderBy(s => (int)s.Attribute("data"));

        string xmlOutPut = string.Empty;

        result.ToList().ForEach(a =>
        {
            xmlOutPut += a;
        });

Where data and Doc is the parent element is your attribute according to your example. File.xml is your xml file name. You will get the sorted output in 'xmlOutPut'

or everything in a single Linq query,

XDocument xdoc = XDocument.Load("XMLFile2.xml");
        string xmlOutPut = string.Empty;

        xdoc.Element("Doc")
          .Elements()
          .OrderBy(s => (int)s.Attribute("data"))
         .ToList().ForEach(a =>
         {
             xmlOutPut += a;
         });

edited Sep 13, 2017 at 13:09

answered Sep 13, 2017 at 11:58

Vijayanath Viswanathan

8,6713 gold badges31 silver badges50 bronze badges

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

1 Comment

Jonathan I Over a year ago

what about the two "element"? Should not they be the nodes name?

Feras Al Sous · Accepted Answer · 2017-09-13 12:38:10Z

0

Sorting

XDocument xDoc = XDocument.Load("FileName.xml");

    var res = xDoc.Element("Doc")
                    .Elements()
                    .OrderByDescending(c => (int) c.Attribute("data"));

Then to save it:

XDocument doc = new XDocument(new XElement("Doc", res));
doc.Save("FileName.xml");

edited Sep 13, 2017 at 12:38

answered Sep 13, 2017 at 12:04

Feras Al Sous

1,0811 gold badge12 silver badges26 bronze badges

3 Comments

Andrew Morton Over a year ago

OP has one file in which the nodes should be sorted.

Jonathan I Over a year ago

Should not we define that the attribute "data" are in the doc child nodes?

Feras Al Sous Over a year ago

I edit the answer , but you should define the attribute data to sort the element determined on value inside attribute data

Collectives™ on Stack Overflow

C# ASP.NET Sort XML Nodes by custom attribute

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related