XML/C# Cannot read read attribute of an element

Question

I have this xml:

<root>
  <property name="com.jaspersoft.studio.js.ic.path" value="/InputControls/pEnforcementStatusID" xmlns="http://jasperreports.sourceforge.net/jasperreports" />
  <property name="com.jaspersoft.studio.js.ic.label" value="Enforcement Status ID" xmlns="http://jasperreports.sourceforge.net/jasperreports" />
  <defaultValueExpression xmlns="http://jasperreports.sourceforge.net/jasperreports"><![CDATA[0]]></defaultValueExpression>
</root>

I need to extract the "properties list with name & value", like this:

name="com.jaspersoft.studio.js.ic.path" with value "/InputControls/pEnforcementStatusID"
name="com.jaspersoft.studio.js.ic.label" with value "Enforcement Status ID"

I try to do that using xpath, xmlreader, linq to xml without success.

You need to show your effort, i.e. code. – Yitzhak Khabinsky Aug 21 '22 at 03:39 — Yitzhak Khabinsky, Aug 21 '22 at 03:39

score 1 · Accepted Answer · edited Aug 21 '22 at 09:50

1

Works with XPath, then enumerate to get the property value.

using System.Xml;
using System.Xml.Linq;

foreach (var current in doc.DocumentElement.SelectNodes("//root//*[local-name()='property']"))
{
    Console.WriteLine($"Name: {current.Attributes["name"].Value}, Value: {current.Attributes["value"].Value}");
}

Demo @ .NET Fiddle

edited Aug 21 '22 at 09:50

Charlieface

52,284
6
19
43

answered Aug 21 '22 at 04:03

Yong Shun

35,286
4
24
46

1

// is slow as it has to go through all descendants, instead use / Likewise using `*` to get around the namespace problem is also slow, instead use `XName` – Charlieface Aug 21 '22 at 09:51

score 1 · Answer 2 · answered Aug 21 '22 at 13:04

I would use XML Linq and create a dictionary

using System;
using System.Linq;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using System.Xml;
using System.Xml.Linq;

namespace ConsoleApp2
{
    class Program
    {
        const string FILENAME = @"c:\temp\test.xml";
        static void Main(string[] args)
        {

            XDocument doc = XDocument.Load(FILENAME);

            Dictionary<string, string> dict = doc.Descendants().Where(x => x.Name.LocalName == "property")
                .GroupBy(x => (string)x.Attribute("name"), y => (string)y.Attribute("value"))
                .ToDictionary(x => x.Key, y => y.FirstOrDefault());

        }

    }
   
}

XML/C# Cannot read read attribute of an element

2 Answers2