Need help to read xml nodes using c# RSS

• • Reply
  

  dj_naveen

  Member

  26 Points

  35 Posts

  Need help to read xml nodes using c#

  Jan 25, 2013 02:41 AM|LINK

  Hi,

  I am trying to read the below xml file

  <NewDataSet>
    <Table>
      <Node1>1.00</Node1>
      <Node2>1000</Node2>
      <Node3>µ¼Ü³É</Node1>
    </Table>
    <Table>
      <Node1>2.00</Node1>
      <Node2>2000</Node2>
      <Node3>µ¼Ü³É</Node1>
    </Table>
  </NewDataSet>

  My C# code is 

  XmlDocument doc = new XmlDocument();
  doc.Load(@"c:\testapp\sample.xml");
  // Root element
  System.Xml.XmlElement conditie = (System.Xml.XmlElement)root.ChildNodes[0].ChildNodes[0];
  string semnal = conditie.ChildNodes[0].InnerText;
  string operator_semnal = conditie.ChildNodes[1].InnerText;
  string valoare = conditie.ChildNodes[2].InnerText;
  string op = root.ChildNodes[0].ChildNodes[1].InnerText;

  I am getting the below error after doc.Load(@"c:\testapp\sample.xml");

  "Invalid character in the given encoding. Line 5, position 12."

  My understanding is the special characters in xml file throws this exeception.

  Kindly help me to overcome this issue and also I need to all the table nodes (need to loop all the table nodes in order to read the

  respective child nodes)

  
   

• • Reply
  

  brijeshvaidy...

  Participant

  848 Points

  231 Posts

  Re: Need help to read xml nodes using c#

  Jan 25, 2013 03:40 AM|LINK

  http://support.microsoft.com/kb/307548?wa=wsignin1.0

  http://stackoverflow.com/questions/4650277/xml-node-reading-for-each-loop

  http://www.drdobbs.com/windows/parsing-xml-files-in-net-using-c/184416669

  Regards,
  Brijesh Vaidya
  India
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Need help to read xml nodes using c#

  Jan 26, 2013 11:54 PM|LINK

  dj_naveen

  "Invalid character in the given encoding. Line 5, position 12."

  My understanding is the special characters in xml file throws this exeception.

  Not only the problem, but your "Node3" without the end of "Node3".

  Please fix something like this:

  <?xml version="1.0" encoding="utf-8" ?>
  <NewDataSet>
    <Table>
      <Node1>1.00</Node1>
      <Node2>1000</Node2>
      <Node3>
        µ¼Ü³É</Node3>
      </Table>
    <Table>
      <Node1>2.00</Node1>
      <Node2>2000</Node2>
      <Node3>
        µ¼Ü³É</Node3>
      </Table>
  </NewDataSet>

   Then your codes should be something like this:

    XmlDocument doc = new XmlDocument();
              doc.Load("XMLFile1.xml");
              // Root element
              System.Xml.XmlElement conditie = (System.Xml.XmlElement)doc.DocumentElement.ChildNodes[0];
              string semnal = conditie.ChildNodes[0].InnerText;
              string operator_semnal = conditie.ChildNodes[1].InnerText;
              string valoare = conditie.ChildNodes[2].InnerText;
              string op = doc.DocumentElement.ChildNodes[0].ChildNodes[1].InnerText;

  • Edited by decker dong - msft on Jan 28, 2013 01:24 AM
  • Edited by dj_naveen on Jan 28, 2013 01:33 AM
  • Edited by decker dong - msft on Jan 31, 2013 01:12 AM
  • Edited by dj_naveen on Feb 01, 2013 06:43 AM
• • Reply
  

  dj_naveen

  Member

  26 Points

  35 Posts

  Re: Need help to read xml nodes using c#

  Jan 28, 2013 01:17 AM|LINK

  Hi Decker Dong - MSFT,

  Thanks for your reply. The xml is a typo mistake. But still not able to load the xml (after correcting xml file) since the xml file contains special character. It seems that the file should be saved using UTF-8  encoding format. After changing the format it seems to working good.

   

  • Edited by dj_naveen on Jan 28, 2013 01:23 AM
  • Marked as answer by dj_naveen on Jan 28, 2013 01:23 AM