use c# how to read xml file

Question

<Reports>
  <Databases>
    <Database>Axxest</Database>
    <Database>Axxest2</Database>
  </Databases>
</Reports>

how to read Axxest, Axxest2 use c# to read xml file like this?

I try this:

XmlDocument xld = new XmlDocument();
xld.Load(XmlPath);
XmlNodeList xnl = xld.SelectSingleNode("Reports").ChildNodes;
tableList.Clear();
foreach (XmlNode xn in xnl)
{
    tableList.Add(xn.InnerText);
}

but something wrong?

XmlDocument xld = new XmlDocument(); xld.Load(XmlPath); XmlNodeList xnl = xld.SelectSingleNode("BackupTables").ChildNodes; tableList.Clear(); foreach (XmlNode xn in xnl) { tableList.Add(xn.InnerText); } — jack.li
– jack.li, Commented Sep 17, 2012 at 7:48
Ok, please include what you have tried right away in future questions. And please also always specify exactly what went wrong, and in what line, and with what message. This will greatly improve your chances on getting suitable answers and good explanations :-) — O. R. Mapper
– O. R. Mapper, Commented Sep 17, 2012 at 8:36

Ria · Accepted Answer · 2012-09-17 08:16:21Z

1

Try SelectNodes method and XPath:

XmlDocument xld = new XmlDocument();
xld.Load(XmlPath);
XmlNodeList xnl = xld.SelectNodes("Reports/Databases/Database");
foreach (XmlNode xn in xnl)
{
    tableList.Add(xn.InnerText);
}

answered Sep 17, 2012 at 8:16

Ria

10.4k3 gold badges35 silver badges62 bronze badges

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

Comments

CloudyMarble · Accepted Answer · 2012-09-17 07:57:28Z

See the Documentation's Example:

StringBuilder output = new StringBuilder();

String xmlString =
        @"<?xml version='1.0'?>
        <!-- This is a sample XML document -->
        <Items>
          <Item>test with a child element <more/> stuff</Item>
        </Items>";
// Create an XmlReader
using (XmlReader reader = XmlReader.Create(new StringReader(xmlString)))
{
    XmlWriterSettings ws = new XmlWriterSettings();
    ws.Indent = true;
    using (XmlWriter writer = XmlWriter.Create(output, ws))
    {

        // Parse the file and display each of the nodes.
        while (reader.Read())
        {
            switch (reader.NodeType)
            {
                case XmlNodeType.Element:
                    writer.WriteStartElement(reader.Name);
                    break;
                case XmlNodeType.Text:
                    writer.WriteString(reader.Value);
                    break;
                case XmlNodeType.XmlDeclaration:
                case XmlNodeType.ProcessingInstruction:
                    writer.WriteProcessingInstruction(reader.Name, reader.Value);
                    break;
                case XmlNodeType.Comment:
                    writer.WriteComment(reader.Value);
                    break;
                case XmlNodeType.EndElement:
                    writer.WriteFullEndElement();
                    break;
            }
        }

    }
}
OutputTextBlock.Text = output.ToString();

Xiaodan Mao · Accepted Answer · 2012-11-02 02:07:26Z

0

If you want to find some nodes in a xml file, you can use XPath for query, and here is all you need in w3 schools.

If you debug the code, you can find the count of xnl is one, it only includes "Databases" node. "SelectSingleNode" means select one node, and in your code, "Reports" is first selected, then return its childnodes, which only contains "Databases". You can try Ria's code, use SelectNodes instead of SelectSingleNode. But you can still use "SelectSingleNode", try this:

XmlNodeList xnl = xld.SelectSingleNode("Reports/Databases").ChildNodes;

Hope it's helpful to you.

edited Nov 2, 2012 at 2:07

answered Sep 17, 2012 at 9:49

Xiaodan Mao

1,7062 gold badges17 silver badges32 bronze badges

Collectives™ on Stack Overflow

use c# how to read xml file

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