VB.Net by API/System.Xml/XmlDataDocument

XmlDataDocument.GetElementFromRow

<source lang="vbnet"> Imports System Imports System.Xml Imports System.Xml.Schema Imports System.IO Imports System.Drawing Imports System.Drawing.Drawing2D Imports System.Collections Imports System.Data Imports System.Windows.Forms

Public Class MainClass

   Shared Sub Main()
       Dim DSStudentClasses As New DataSet()
       Dim tmpNode As XmlNode
       " Load the schema into the DataSet
       DSStudentClasses.ReadXmlSchema("StudentClasses.xsd")
       " Load the DataSet into the data document
       Dim XDocStudents As New XmlDataDocument(DSStudentClasses)
       " Load the data into the data document
       XDocStudents.Load("Students.xml")
       Console.WriteLine("Students in DataSet:")
       Dim Row As DataRow
       For Each Row In DSStudentClasses.Tables("Student").Rows
           Console.WriteLine("{0}:{1}", Row("Name"), Row("GPA"))
           tmpNode = XDocStudents.GetElementFromRow(Row)
           Console.WriteLine( _
                 "   Locker Combination (from XML, not DataSet): {0}", _
                 tmpNode.SelectSingleNode("LockerCombination").InnerText)
           Dim Subject As DataRow
           For Each Subject In Row.GetChildRows("StudentClasses")
               Console.WriteLine("   {0}", Subject("Title"))
           Next
       Next
   End Sub

End Class "student.xml "<?xml version="1.0" encoding="utf-8" ?> "<Students> " <Student ID="1"> " <Name>Joe Wang</Name> " <Age>30</Age> " <GPA>2.95</GPA> " <LockerCombination>10-12-35</LockerCombination> " <Class Title="Biology" Room="100" /> " <Class Title="English Lit" Room="101" /> " </Student> "</Students> "student.xsd "<?xml version="1.0" standalone="yes"?> "<xs:schema id="Students" xmlns="" " xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> " <xs:element name="Students" msdata:IsDataSet="true"> " <xs:complexType> " <xs:choice maxOccurs="unbounded"> " <xs:element name="Student"> " <xs:complexType> " <xs:sequence> " <xs:element name="Name" type="xs:string" " minOccurs="0" msdata:Ordinal="0" /> " <xs:element name="GPA" type="xs:float" " minOccurs="0" msdata:Ordinal="2" /> " <xs:element name="Class" " minOccurs="0" maxOccurs="unbounded"> " <xs:complexType> " <xs:attribute name="Title" type="xs:string" /> " <xs:attribute name="Room" type="xs:string" /> " <xs:attribute name="StudentID" type="xs:int" " use="prohibited" /> " </xs:complexType> " </xs:element> " </xs:sequence> " <xs:attribute name="ID" type="xs:int" /> " </xs:complexType> " </xs:element> " </xs:choice> " </xs:complexType> " <xs:unique name="StudentID" msdata:PrimaryKey="true"> " <xs:selector xpath=".//Student" /> " <xs:field xpath="@ID" /> " </xs:unique> " <xs:keyref name="StudentClasses" refer="StudentID" " msdata:IsNested="true"> " <xs:selector xpath=".//Class" /> " <xs:field xpath="@StudentID" /> " </xs:keyref> " </xs:element> "</xs:schema>

 </source>