reading xml in vb.net 2008

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • chriskaza81
    New Member
    • Nov 2007
    • 52
    #1

    reading xml in vb.net 2008

    helo all well i have the below xml document
    i want somehow read each node of the this xml in vb.net somebody help with code example?? thanks




    <?xml version="1.0" encoding="UTF-8" ?>
    - <soapenv:Envelo pe xmlns:soapenv=" http://schemas.xmlsoap .org/soap/envelope/" xmlns:xsd="http ://www.w3.org/2001/XMLSchema" xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance">
    - <soapenv:Body >
    - <PRO01 xmlns="http://www.realize.gr/" xmlns:n="http://tempuri.org/" xmlns:var="urn: var" xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance">
    - <INTERFACE_DETA ILS>
    <ORIGIN_TRANS_I D>29386766</ORIGIN_TRANS_ID >
    <ORIGIN_VERSION _ID>1</ORIGIN_VERSION_ ID>
    <TIMESTAMP>20 08-08-01T09:06:28</TIMESTAMP>
    <TRANSACTION_TY PE>PRO01</TRANSACTION_TYP E>
    <SYSTEM>EDDIE </SYSTEM>
    <SENDER>EDDIE </SENDER>
    <RECEIVER>REA L</RECEIVER>
    </INTERFACE_DETAI LS>
    - <ORDER_OBJECT >
    <BUSINESS_UNIT> 21</BUSINESS_UNIT>
    <BRANCH>0405</BRANCH>
    <ORDER_NO>29386 766</ORDER_NO>
    <ROLE>1</ROLE>
    <B_TOWN>5783</B_TOWN>
    <ORDER_TYPE>201 </ORDER_TYPE>
    <PARTICIPANT_SU RNAME>ΕΥΑΓΓΕΛΑΤ ΟΣ</PARTICIPANT_SUR NAME>
    <PARTICIPANT_NA ME>ΝΙΚΟΛΑΟΣ</PARTICIPANT_NAM E>
    <PARTICIPANT_PH ONE>2109610306</PARTICIPANT_PHO NE>
    <PARTICIPANT_MO BILE_PHONE>6976 431222</PARTICIPANT_MOB ILE_PHONE>
    <LOANER_CIF>017 36484</LOANER_CIF>
    <LOANER_SURNAME >ΕΥΑΓΓΕΛΑΤΟΣ </LOANER_SURNAME>
    <LOANER_NAME>ΝΙ ΚΟΛΑΟΣ</LOANER_NAME>
    <STREET1ID>1474 66</STREET1ID>
    <STREET1NUMFROM >44</STREET1NUMFROM>
    <STREET2ID>1474 84</STREET2ID>
    <STREET3ID>1474 78</STREET3ID>
    <STREET4ID>1474 63</STREET4ID>
    <IS_ANGULAR>fal se</IS_ANGULAR>
    <LOCALENAME>ΤΕΡ ΨΙΘΕΑ</LOCALENAME>
    <B_PREFECTURE>9 </B_PREFECTURE>
    <B_PROVINCE>5 1</B_PROVINCE>
    <B_MUNICIPALITY >945</B_MUNICIPALITY>
    <B_ZIP_CODE>193 </B_ZIP_CODE>
    <COMMENTS>H ΟΔΟΣ ΑΓΙΟΥ ΤΡΥΦΩΝΟΣ ΕΙΝΑΙ ΑΔΙΕΞΟΔΟΣ ΔΡΟΜΟΣ ΠΟΥ ΚΑΤΑΛΗΓΕΙ ΣΤΗΝ ΟΔΟ ΠΛΑΠΟΥΤΑ.</COMMENTS>
    - <PROPERTY_STRUC TURE>
    - <PRO01PropertyS tructure>
    <PROPERTYNAME>Υ Π' ΑΡΙΘΜΟΝ ΕΝΑ (Ι)</PROPERTYNAME>
    <PROPERTY_AA>20 9086</PROPERTY_AA>
    <PROPERTY_SUBTY PE>1</PROPERTY_SUBTYP E>
    <PROPERTY_PERCE NTAGE>158.0</PROPERTY_PERCEN TAGE>
    - <FLOOR>
    - <PRO01Floor>
    <PROPERTY_FLOOR _DESCR>ΥΠ΄ΑΡΙΘΜ ΟΝ ΕΝΑ(Ι) ΔΙΑΜΕΡΙΣΜΑ</PROPERTY_FLOOR_ DESCR>
    <PROPERTY_FLOOR >6</PROPERTY_FLOOR>
    - <PROPERTY_ARE A>
    - <PRO01PropertyA rea>
    <PROPERTY_AREA> 118.0</PROPERTY_AREA>
    <PROPERTY_AREA_ TYPE>2</PROPERTY_AREA_T YPE>
    </PRO01PropertyAr ea>
    - <PRO01PropertyA rea>
    <PROPERTY_AREA> 118.0</PROPERTY_AREA>
    <PROPERTY_AREA_ TYPE>1</PROPERTY_AREA_T YPE>
    </PRO01PropertyAr ea>
    - <PRO01PropertyA rea>
    <PROPERTY_AREA> 0.0</PROPERTY_AREA>
    <PROPERTY_AREA_ TYPE>5</PROPERTY_AREA_T YPE>
    </PRO01PropertyAr ea>
    - <PRO01PropertyA rea>
    <PROPERTY_AREA> 0.0</PROPERTY_AREA>
    <PROPERTY_AREA_ TYPE>3</PROPERTY_AREA_T YPE>
    </PRO01PropertyAr ea>
    </PROPERTY_AREA>
    </PRO01Floor>
    </FLOOR>
    - <PROPERTY_DETAI LS_TEXT>
    - <PRO01PropertyD etailsText>
    <PROPERTY_DETAI LS_TEXT>3</PROPERTY_DETAIL S_TEXT>
    <PROPERTY_DETAI LS_TEXT_ANSWER> ΣΑΛΟΤΡΑΠΕΖΑ ΡΙΑ, ΧΩΛΛ, 3 ΚΟΙΤΩΝΕΣ, ΜΑΓΕΙΡΕΙΟ, ΛΟΥΤΡΟΑΠΟΧΩΡΗΤΗ ΡΙΟ, ΚΑΙ ΑΠΟΧΩΡΗΤΗΡΙ Ο ΞΕΝΩΝ.</PROPERTY_DETAIL S_TEXT_ANSWER>
    </PRO01PropertyDe tailsText>
    - <PRO01PropertyD etailsText>
    <PROPERTY_DETAI LS_TEXT>2</PROPERTY_DETAIL S_TEXT>
    <PROPERTY_DETAI LS_TEXT_ANSWER> 1121/74</PROPERTY_DETAIL S_TEXT_ANSWER>
    </PRO01PropertyDe tailsText>
    </PROPERTY_DETAIL S_TEXT>
    - <PROPERTY_DETAI LS_BOOLEAN>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>11</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>4</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>7</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>true</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>10</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>3</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>true</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>14</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>6</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>2</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>9</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>true</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>5</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>12</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>false</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    - <PRO01PropertyD etailsBoolean>
    <PROPERTY_DETAI LS_BOOLEAN>1</PROPERTY_DETAIL S_BOOLEAN>
    <PROPERTY_DETAI LS_BOOLEAN_ANSW ER>true</PROPERTY_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01PropertyDe tailsBoolean>
    </PROPERTY_DETAIL S_BOOLEAN>
    - <PROPERTY_DETAI LS_NUMBER>
    - <PRO01PropertyD etailsNumber>
    <PROPERTY_DETAI LS_NUMBER>4</PROPERTY_DETAIL S_NUMBER>
    <PROPERTY_DETAI LS_NUMBER_ANSWE R>1</PROPERTY_DETAIL S_NUMBER_ANSWER >
    <PROPERTY_DETAI LS_NUMBER_CONST RUCTION>1</PROPERTY_DETAIL S_NUMBER_CONSTR UCTION>
    </PRO01PropertyDe tailsNumber>
    - <PRO01PropertyD etailsNumber>
    <PROPERTY_DETAI LS_NUMBER>2</PROPERTY_DETAIL S_NUMBER>
    <PROPERTY_DETAI LS_NUMBER_ANSWE R>2</PROPERTY_DETAIL S_NUMBER_ANSWER >
    <PROPERTY_DETAI LS_NUMBER_MAINT ENANCE>2</PROPERTY_DETAIL S_NUMBER_MAINTE NANCE>
    </PRO01PropertyDe tailsNumber>
    - <PRO01PropertyD etailsNumber>
    <PROPERTY_DETAI LS_NUMBER>3</PROPERTY_DETAIL S_NUMBER>
    <PROPERTY_DETAI LS_NUMBER_ANSWE R>1</PROPERTY_DETAIL S_NUMBER_ANSWER >
    <PROPERTY_DETAI LS_NUMBER_HEATI NG>1</PROPERTY_DETAIL S_NUMBER_HEATIN G>
    </PRO01PropertyDe tailsNumber>
    </PROPERTY_DETAIL S_NUMBER>
    </PRO01PropertySt ructure>
    </PROPERTY_STRUCT URE>
    - <APPLICATION_CO NTRACT>
    <APPLICATION_CO NTRACT_NO>20381 50</APPLICATION_CON TRACT_NO>
    </APPLICATION_CON TRACT>
    - <BUILDING_DETAI LS_BOOLEAN>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>2</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>0</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>7</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>1</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>4</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>1</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>9</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>0</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>8</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>1</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>5</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>0</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>1</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>1</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    - <PRO01BuildingD etailsBoolean>
    <BUILDING_DETAI LS_BOOLEAN>3</BUILDING_DETAIL S_BOOLEAN>
    <BUILDING_DETAI LS_BOOLEAN_ANSW ER>0</BUILDING_DETAIL S_BOOLEAN_ANSWE R>
    </PRO01BuildingDe tailsBoolean>
    </BUILDING_DETAIL S_BOOLEAN>
    - <BUILDING_DETAI LS_TEXT>
    - <PRO01BuildingD etailsText>
    <BUILDING_DETAI LS_TEXT>2</BUILDING_DETAIL S_TEXT>
    <BUILDING_DETAI LS_TEXT_ANSWER> 1975</BUILDING_DETAIL S_TEXT_ANSWER>
    </PRO01BuildingDe tailsText>
    </BUILDING_DETAIL S_TEXT>
    - <BUILDING_DETAI LS_NUMBER>
    - <PRO01BuildingD etailsNumber>
    <BUILDING_DETAI LS_NUMBER>1</BUILDING_DETAIL S_NUMBER>
    <BUILDING_DETAI LS_NUMBER_ANSWE R>3</BUILDING_DETAIL S_NUMBER_ANSWER >
    </PRO01BuildingDe tailsNumber>
    - <PRO01BuildingD etailsNumber>
    <BUILDING_DETAI LS_NUMBER>3</BUILDING_DETAIL S_NUMBER>
    <BUILDING_DETAI LS_NUMBER_ANSWE R>450</BUILDING_DETAIL S_NUMBER_ANSWER >
    </PRO01BuildingDe tailsNumber>
    </BUILDING_DETAIL S_NUMBER>
    </ORDER_OBJECT>
    </PRO01>
    </soapenv:Body>
    </soapenv:Envelop e>
    Tags: None
    • jsweeney
      New Member
      • Aug 2008
      • 2
      #2
      I have a routine that reads through an xml document to create the nodes on a Treeview. The code (without the CASE statements in the SELECT clause) is shown below. I hope this helps.

      Code:
      pXmlDocument = New XmlDocument()
pXmlDocument.LoadXml(pXMLString)

For Each pXmlNode In pXmlDocument.ChildNodes(1).ChildNodes

	Select Case pXmlNode.Name


	End Select

Next

        Comment

        • chriskaza81
          New Member
          • Nov 2007
          • 52
          #3
          thanks!!

          it was helpfull although i found a way after some ours searching

            Comment

            Previous template Next
            Working...