How to get the xml node value in string

Question

I tried the below code to get the value of a particular node  but while loading the xml this exception is thrown   Exception      Data at the root level is invalid  Line 1  position 1    XML   lt  xml version  1 0   gt   lt Data xmlns xsd  http   www w3 org 2001 XMLSchema  xmlns xsi  http   www w3 org 2001 XMLSchema-instance  gt        lt Date gt 11-07-2013 lt  Date gt        lt Start Time gt PM 01 37 11 lt  Start Time gt        lt End Time gt PM 01 37 14 lt  End Time gt        lt Total Time gt 00 00 03 lt  Total Time gt        lt Interval Time  gt       lt Worked Time gt 00 00 03 lt  Worked Time gt        lt Short Fall gt 08 29 57 lt  Short Fall gt        lt Gain Time gt 00 00 00 lt  Gain Time gt    lt  Data gt    C    XmlDocument xml   new XmlDocument    filePath     D  Work Time Calculator 10-07-2013 xml   xml LoadXml filePath       Exception occurs here  XmlNode node   xml SelectSingleNode   Data     Short Fall    string id   node  Short Fall   InnerText    Modified Code  C    XmlDocument xml   new XmlDocument    filePath     D  Work Time Calculator 10-07-2013 xml   xml Load filePath     XmlNode node   xml SelectSingleNode   Data     Short Fall    string id   node  Short Fall   InnerText     Exception occurs here   Object reference not set to an instance of an object

User · Answer

XmlDocument d   new XmlDocument    d Load   D  Work Time Calculator 10-07-2013 xml    XmlNodeList n   d GetElementsByTagName  Short Fall    if n    null        Console WriteLine n 0  InnerText     Will output  08 29 57     or you could wrap in foreach loop to print each value  XmlDocument d   new XmlDocument    d Load   D  Work Time Calculator 10-07-2013 xml    XmlNodeList n   d GetElementsByTagName  Short Fall    if n    null        foreach XmlNode curr in n            Console WriteLine curr InnerText

User · Answer

The problem in your code is xml LoadXml filePath       LoadXml method take parameter as xml data not the xml file path   Try this code     string xmlFile   File ReadAllText   D  Work Time Calculator 10-07-2013 xml                    XmlDocument xmldoc   new XmlDocument                    xmldoc LoadXml xmlFile                   XmlNodeList nodeList   xmldoc GetElementsByTagName  Short Fall                    string Short Fall string Empty                  foreach  XmlNode node in nodeList                                        Short Fall   node InnerText                      Edit  Seeing the last edit of your question i found the solution   Just replace the below 2 lines   XmlNode node   xml SelectSingleNode   Data     Short Fall    string id   node  Short Fall   InnerText     Exception occurs here   Object reference not set to an instance of an object      with   string id   xml SelectSingleNode  Data Short Fall   InnerText    It should solve your problem or you can use the solution i provided earlier

User · Answer

These posts helped me get past a couple of issues I had creating a CLR Stored Procedure with Restful API call against Infor M3 API  The XML Result from these API s look like this for my code below  miResult xmlns  quot http   lawson com m3 miaccess quot  gt       lt Program gt MMS200MI lt  Program gt       lt Transaction gt Get lt  Transaction gt       lt Metadata gt     lt  Metadata gt       lt MIRecord gt           lt RowIndex gt 0 lt  RowIndex gt           lt NameValue gt               lt Name gt STAT lt  Name gt               lt Value gt 20 lt  Value gt           lt  NameValue gt           lt NameValue gt               lt Name gt ITNO lt  Name gt               lt Value gt ITEM123 lt  Value gt           lt  NameValue gt           lt NameValue gt               lt Name gt ITDS lt  Name gt               lt Value gt ITEM DESCRIPTION 123  lt  Value gt           lt  NameValue gt       The CLR C  Code to accomplish listing out the Resultset from the API works as shown below  using System  using System Data  using System Data SqlClient  using System Data SqlTypes  using System IO  using System Net  using System Text  using System Xml  using Microsoft SqlServer Server   public partial class StoredProcedures        Microsoft SqlServer Server SqlProcedure      public static void CallM3API Test1                 SqlPipe pipe msg   SqlContext Pipe          try                       HttpWebRequest request    HttpWebRequest WebRequest Create  quot https   M3Server domain com 12345 m3api-rest execute MMS200MI Get ITNO ITEM123 quot                 request Method    quot Get quot               request ContentLength   0               request Credentials   new NetworkCredential  quot myUserID domain com quot    quot MyPassword quot                request ContentType    quot application xml quot               request Accept    quot application xml quot                using  HttpWebResponse response    HttpWebResponse request GetResponse                                      using  Stream receiveStream   response GetResponseStream                                                  using  StreamReader readStream   new StreamReader receiveStream  Encoding UTF8                                                         string strContent   readStream ReadToEnd                                XmlDocument xdoc   new XmlDocument                                xdoc LoadXml strContent                               try                                                               SqlPipe pipe   SqlContext Pipe                                     Define Output Columns and Max Length of each Column in the Resultset                                     SqlMetaData   cols   new SqlMetaData 2                                   cols 0    new SqlMetaData  quot Name quot   SqlDbType NVarChar  50                                   cols 1    new SqlMetaData  quot Value quot   SqlDbType NVarChar  120                                   SqlDataRecord record   new SqlDataRecord cols                                    pipe SendResultsStart record                                    XmlNodeList nodeList   xdoc GetElementsByTagName  quot NameValue quot                                      List ALL Output Names   Values                                 foreach  XmlNode nodeRes in nodeList                                                                        record SetSqlString 0  nodeRes  quot Name quot   InnerText                                       record SetSqlString 1  nodeRes  quot Value quot   InnerText                                        pipe SendResultsRow record                                                                      pipe SendResultsEnd                                                              catch  Exception ex                                                                SqlContext Pipe Send  quot Error  readStream    quot    ex Message                                                                                                                 catch  Exception ex                        SqlContext Pipe Send  quot Error  CallM3API Test1    quot    ex Message                       Hopefully this provides helpful

User · Answer

You should use  Load and not  LoadXML  MSDN Link   The LoadXml method is for loading an XML string directly  You want to use the Load method instead    ref   Link

[c#] How to get the xml node value in string

Examples related to c#

Examples related to .net

Examples related to xml