Read from xml to string list C#

Question

I have these XML file:

<cteProc xmlns="http://www.portalfiscal.inf.br/cte" versao="1.04" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <CTe xmlns="http://www.portalfiscal.inf.br/cte">
        <infCte versao="1.04" Id="CTexxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx">
            <ide>
                <compl>
                    <emit>
                        <rem>
                            <CNPJ>11111111111</CNPJ>
                            <IE>2222222</IE>
                            <xNome>Teste</xNome>
                            <enderReme>
                                <xLgr>xxxxxxx xxxxxx</xLgr>
                                <nro>S/N</nro>
                                <xCpl>AREA C</xCpl>
                                <xBairro>PARQ. xxxxxx</xBairro>
                                <cMun>125455</cMun>
                                <xMun>xxxxxx</xMun>
                                <CEP>548848</CEP>
                                <UF>AA</UF>
                                <xPais>BRASIL</xPais>
                            </enderReme>
                            <infNFe>
                                **<chave>1</chave>**
                                **<chave>2</chave>**
                                **<chave>3</chave>**
                            </infNFe>
                        </rem>
                        <exped>
                            <CNPJ>2342342342342</CNPJ>
                            <IE>15342683242345480</IE>
                                ...........................

And I need to get values and put inside a string

I try to do this:

var ListaChave = new List<string>();

var lista = (from c in xDoc.Descendants(ns + "/rem/chave") select c.Value).ToList();

foreach (string s in lista)
  {
    add the values.....
  }

But the s var is null. I don´t know how to get these values. Anybody can help me please!?

What value has ns variable when you call Descendants() method? — HuorSwords
– HuorSwords, Commented Jun 20, 2013 at 16:44
Change your Descendants portion to Descendants(ns + "/rem/infNFe/chave"). The chave element is a child of theinfNFe element. — Tim
– Tim, Commented Jun 20, 2013 at 16:44

Sam I am says Reinstate Monica · Accepted Answer · 2013-06-20 17:07:24Z

3

Use linq to xml

XDocument doc = XDocument.Load("XMLFile1.xml");

XNamespace ns = @"http://www.portalfiscal.inf.br/cte";

List<string> strList = doc.Descendants(ns+"rem").Descendants(ns+"chave").Select(e => e.Value).ToList();

and alternatively, you can have more control by doing things like

edited Jun 20, 2013 at 17:07

answered Jun 20, 2013 at 16:44

Sam I am says Reinstate Monica

31.3k12 gold badges74 silver badges101 bronze badges

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

Comments

Tim · Accepted Answer · 2013-06-20 16:49:08Z

1

You're missing an element in the path you passed to Descendants. In your XML document the chave elements are children of infNFe. Your LINQ query is looking for chave elements under "rem", and not finding any, hence the null result.

Change your query to this:

var lista = (from c in xDoc.Descendants(ns + "/rem/infNFe/chave") 
             select c.Value).ToList();

And you should get what you're looking for, as long as the ns is set correctly.

answered Jun 20, 2013 at 16:49

Tim

28.6k8 gold badges65 silver badges80 bronze badges

Comments

Santosh Panda · Accepted Answer · 2013-06-20 16:48:27Z

0

You can try with this code by just adding the infNFe:

var ListaChave = new List<string>();

var lista = (from c in xDoc.Descendants(ns + "/rem/infNFe/chave") 
             select c.Value).ToList();

foreach (string s in lista)
{
   add the values.....
}

answered Jun 20, 2013 at 16:48

Santosh Panda

7,3418 gold badges45 silver badges58 bronze badges

Collectives™ on Stack Overflow

Read from xml to string list C#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related