DavRed
New member
I'm a newcomer to VB.net having used VB6 for some years - I'm struggling with handling XML files in VB projects. I've tried the suggestions on MSDN with no real success - Schema is reading in but no data.
What I'd like to be able to do is read in an XML file by node and display relevant data. If I could edit the data and write-back to XMLK so much the better, but one step at a time!!!
Here's an example of the XML:
?xml version="1.0" encoding="UTF-8"?>
<!-- Serco-Import High School: Test Schedule -->
<!-- TimeTabler 5.030 to SIMS.net at 14/06/2010 12:17 -->
<ACADEMIC_IMPORT_CURRICULUM>
<VERSION>1.0</VERSION>
<PERIOD INDEX="1">
<LESSON CLASS="$7A/Fr"
TEACHER="LM"
ROOM="L2"/>
<LESSON CLASS="$7B/Mu"
TEACHER="DW"
ROOM="L29"/>
<LESSON CLASS="$8A/Mu"
TEACHER="SA"
ROOM="L28"/>
<LESSON CLASS="$8B/RE"
TEACHER="JR"
ROOM="L8"/>
</PERIOD>
<PERIOD INDEX="2">
<LESSON CLASS="$7A/Mu"
TEACHER="DW"
ROOM="L29"/>
<LESSON CLASS="$7B/Fr"
TEACHER="EBr"
ROOM="L9"/>
<LESSON CLASS="$8A/Fr"
TEACHER="FE"
ROOM="L24"/>
<LESSON CLASS="$8B/IC"
TEACHER="GNe"
ROOM="L17"/>
<DUTY NCC="PPA"
TEACHER="JV"/>
</PERIOD>
<PERIOD INDEX="3">
<LESSON CLASS="$7A/Ge"
TEACHER="DKe"
ROOM="L22"/>
<LESSON CLASS="$7B/IC"
TEACHER="GNe"
ROOM="L17"/>
<LESSON CLASS="$8z/Ma1"
TEACHER="FHi"
ROOM="L19"/>
<LESSON CLASS="$8z/Ma2"
TEACHER="AHa"
ROOM="L1"/>
<LESSON CLASS="$8z/Ma3"
TEACHER="JWi"
ROOM="L18"/>
</PERIOD>
<PERIOD INDEX="4">
<LESSON CLASS="$7A/Hi"
TEACHER="RR"
ROOM="L30"/>
<LESSON CLASS="$7B/Hi"
TEACHER="JC"
ROOM="L22"/>
<LESSON CLASS="$8A/IC"
TEACHER="GNe"
ROOM="L17"/>
<LESSON CLASS="$8B/Fr"
TEACHER="JPa"
ROOM="L9"/>
<DUTY NCC="PPA"
TEACHER="FHi"/>
</PERIOD>
<PERIOD INDEX="5">
<LESSON CLASS="$7A/Sc"
TEACHER="KJo"
ROOM="L4"/>
<LESSON CLASS="$7B/Ma"
TEACHER="JM"
ROOM="L18"/>
<LESSON CLASS="$8A/En"
TEACHER="CNe"
ROOM="L2"/>
<LESSON CLASS="$8B/Hi"
TEACHER="TO"
ROOM="L24"/>
</PERIOD>
<PERIOD INDEX="6">
<LESSON CLASS="$7A/En"
TEACHER="AJo"
ROOM="L6"/>
<LESSON CLASS="$7B/En"
TEACHER="DA"
ROOM="L5"/>
<LESSON CLASS="$8A/Sc"
TEACHER="GWa"
ROOM="L1"/>
<LESSON CLASS="$8B/En"
TEACHER="DS"
ROOM="L28"/>
</PERIOD>
</ACADEMIC_IMPORT_CURRICULUM>
Anyone assist please?
Thanks
David
What I'd like to be able to do is read in an XML file by node and display relevant data. If I could edit the data and write-back to XMLK so much the better, but one step at a time!!!
Here's an example of the XML:
?xml version="1.0" encoding="UTF-8"?>
<!-- Serco-Import High School: Test Schedule -->
<!-- TimeTabler 5.030 to SIMS.net at 14/06/2010 12:17 -->
<ACADEMIC_IMPORT_CURRICULUM>
<VERSION>1.0</VERSION>
<PERIOD INDEX="1">
<LESSON CLASS="$7A/Fr"
TEACHER="LM"
ROOM="L2"/>
<LESSON CLASS="$7B/Mu"
TEACHER="DW"
ROOM="L29"/>
<LESSON CLASS="$8A/Mu"
TEACHER="SA"
ROOM="L28"/>
<LESSON CLASS="$8B/RE"
TEACHER="JR"
ROOM="L8"/>
</PERIOD>
<PERIOD INDEX="2">
<LESSON CLASS="$7A/Mu"
TEACHER="DW"
ROOM="L29"/>
<LESSON CLASS="$7B/Fr"
TEACHER="EBr"
ROOM="L9"/>
<LESSON CLASS="$8A/Fr"
TEACHER="FE"
ROOM="L24"/>
<LESSON CLASS="$8B/IC"
TEACHER="GNe"
ROOM="L17"/>
<DUTY NCC="PPA"
TEACHER="JV"/>
</PERIOD>
<PERIOD INDEX="3">
<LESSON CLASS="$7A/Ge"
TEACHER="DKe"
ROOM="L22"/>
<LESSON CLASS="$7B/IC"
TEACHER="GNe"
ROOM="L17"/>
<LESSON CLASS="$8z/Ma1"
TEACHER="FHi"
ROOM="L19"/>
<LESSON CLASS="$8z/Ma2"
TEACHER="AHa"
ROOM="L1"/>
<LESSON CLASS="$8z/Ma3"
TEACHER="JWi"
ROOM="L18"/>
</PERIOD>
<PERIOD INDEX="4">
<LESSON CLASS="$7A/Hi"
TEACHER="RR"
ROOM="L30"/>
<LESSON CLASS="$7B/Hi"
TEACHER="JC"
ROOM="L22"/>
<LESSON CLASS="$8A/IC"
TEACHER="GNe"
ROOM="L17"/>
<LESSON CLASS="$8B/Fr"
TEACHER="JPa"
ROOM="L9"/>
<DUTY NCC="PPA"
TEACHER="FHi"/>
</PERIOD>
<PERIOD INDEX="5">
<LESSON CLASS="$7A/Sc"
TEACHER="KJo"
ROOM="L4"/>
<LESSON CLASS="$7B/Ma"
TEACHER="JM"
ROOM="L18"/>
<LESSON CLASS="$8A/En"
TEACHER="CNe"
ROOM="L2"/>
<LESSON CLASS="$8B/Hi"
TEACHER="TO"
ROOM="L24"/>
</PERIOD>
<PERIOD INDEX="6">
<LESSON CLASS="$7A/En"
TEACHER="AJo"
ROOM="L6"/>
<LESSON CLASS="$7B/En"
TEACHER="DA"
ROOM="L5"/>
<LESSON CLASS="$8A/Sc"
TEACHER="GWa"
ROOM="L1"/>
<LESSON CLASS="$8B/En"
TEACHER="DS"
ROOM="L28"/>
</PERIOD>
</ACADEMIC_IMPORT_CURRICULUM>
Anyone assist please?
Thanks
David
