Home / Questions / 151299
Accepted
Efrain Mejias C
Asked: 2020-03-29 11:18:01 +0800 CST 2020-03-29 11:18:01 +0800 CST

How to get value of child elements of a node in XML document?

  • 772

To get the value of an element in XML document, I write something like this:

XmlNodeList nodo = documentoXml.GetElementsByTagName("Fecha");

This returns me a list of the elements with the specified name, and I can access their values ​​by their position in the list. For example:

string Fecha = nodo[0].InnerXml;

But if the element has children like the Detail element, how can I get their values? for instance:

 <?xml version="1.0" encoding="UTF-8"?>
-<FacturaElectronica xmlns="https://tribunet.hacienda.go.cr/docs/esquemas/2017/v4.2/facturaElectronica" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Clave>50628031800310140886100100001010000000003145592145</Clave>
<NumeroConsecutivo>00100001010000000003</NumeroConsecutivo>
<FechaEmision>2018-03-28T08:00:24-04:00</FechaEmision>

-<Emisor>
 <Nombre>NEOTECNOLOGIAS SA</Nombre>
-<Identificacion>
  <Tipo>02</Tipo>
  <Numero>3101408861</Numero>
</Identificacion>
<NombreComercial>NEOTECNOLOGIAS SA</NombreComercial>

-<Ubicacion>
  <Provincia>1</Provincia>
  <Canton>02</Canton>
  <Distrito>01</Distrito>
 <Barrio>01</Barrio>
  <OtrasSenas>CENTRO CORPORATIVO PLAZA ROBLE EDIFICIO LAS TERRAZAS 5TO   PISO</OtrasSenas>
</Ubicacion>

-<Telefono>
  <CodigoPais>506</CodigoPais>
  <NumTelefono>40701540</NumTelefono>
</Telefono>

-<Fax>
  <CodigoPais>506</CodigoPais>
  <NumTelefono>40701540</NumTelefono>
</Fax>
 <CorreoElectronico>[email protected]</CorreoElectronico>
</Emisor>

-<Receptor>
 <Nombre>Dental Care</Nombre>
-<Identificacion>
  <Tipo>02</Tipo>
  <Numero>3001123208</Numero>
</Identificacion>

<NombreComercial>Dental Care</NombreComercial>

-<Ubicacion>
  <Provincia>1</Provincia>
  <Canton>01</Canton>
  <Distrito>01</Distrito>
  <Barrio>01</Barrio>
  <OtrasSenas>Amon</OtrasSenas>
</Ubicacion>

-<Telefono>
  <CodigoPais>506</CodigoPais
  <NumTelefono>40701590</NumTelefono>
</Telefono>

-<Fax>
   <CodigoPais>506</CodigoPais>
   <NumTelefono>40701590</NumTelefono>
</Fax>
   <CorreoElectronico>[email protected]</CorreoElectronico>
</Receptor>
    </FacturaElectronica>

How can I get the values ​​of Number and Reference children of the Detail node?

c#

3 Answers

  1. Best Answer

    Well, based on your way of working, you recover the Detail node and within it you recover the nodes (which would be subnodes), and you specify which ones you want to recover.

    I enclose a small code, I am not so much of C#, I stayed in VB, but I hope you understand the idea.

    private void Main()
    {
        XmlDocument doc;
        XmlNodeList nodo;
        XmlNode elemento;
        doc = new XmlDocument();
        doc.Load("C:\\Users\\Usuario\\Desktop\\file.xml");
        nodo = doc.GetElementsByTagName("Detalle");
        foreach (var elemento in nodo)
        {
            Console.WriteLine(elemento.SelectSingleNode("numero").InnerText);
            Console.WriteLine(elemento.SelectSingleNode("referencia").InnerText);
            Console.ReadLine();
        }
    }
    • 2

  2. If you dare to use linq to xml you could use something like this

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


public class Program
{
    public static void Main()
    {

        string xml = @"<Factura> 
               <Fecha> 28/03/2018 </Fecha>
                <Detalle> 
                    <numero>423561</numero>
                    <referencia>vnb432432</referencia>
                </Detalle>
            </Factura>";

        var doc = XDocument.Parse(xml);

        var result = from factura in doc.Descendants("Factura")
            select new {
               Fecha = factura.Element("Fecha").Value,
               Detalle = new {
                 numero = factura.Element("Detalle").Element("numero").Value,
                 referencia = factura.Element("Detalle").Element("referencia").Value,
            }
        };

        foreach(var item in result){
            Console.WriteLine(item.Fecha);
            Console.WriteLine(item.Detalle.numero);
            Console.WriteLine(item.Detalle.referencia);
        }
    }
}

    as you will see it is very simple to work the nodes and convert this to objects

    • 2

  3. One way to obtain the values ​​of elements of an XML document is using XPATH syntax, in this way it can be accessed directly or randomly according to its position within the document...

    I explain

    For example, if there are several elements called Number in the document and we want to obtain the value of the second element of this type, we do the following:

    public void ObtenerValorDeNodo(XmlDocument documentoXml)
        {
            string uri = "https://tribunet.hacienda.go.cr/docs/esquemas/2017/v4.2/facturaElectronica";
            XmlNamespaceManager nS = new XmlNamespaceManager(documentoXml.NameTable);
            nS.AddNamespace("xs", uri);
            XmlNode  nodo = documentoXml.SelectSingleNode("(//xs:Numero)[2]", nS);
            string valorNumero = nodo.InnerText;
        }
    • 0