The System.Xml.XmlDataDocument Class

Supported Versions

Public Members

Overview

Using this class you can create an implementation of the parent XmlDocument class that is capable of representing data in both a standard XML tree format, as well as a relational DataSet format. In fact, the XMLDataSet class can be related to a System.Data.DataSet, allowing the same body of data to be manipulated using relational or XML DOM-compliant APIs.

Example (VB.NET): How to read in and retrieve an XML document from a DataSet and an XmlDataSet.

In this example, we create two XmlTextReaders that load the same XML document. The contents of the first XmlTextReader are read into a DataSet table and then displayed in their native XML format. The contents of the second XmlTextReader are loaded into an XmlDataDocument and then displayed.

        Dim objDataSet As New System.Data.DataSet

        Dim objTable As New System.Data.DataTable

        Dim objReader1 As New System.Xml.XmlTextReader("C:\sample.xml")

        Dim objReader2 As New System.Xml.XmlTextReader("C:\sample.xml")

        Dim objStringReader As System.IO.TextReader

        Dim objXmlDataDocument As New System.Xml.XmlDataDocument

        Dim strValues As String

        objDataSet.DataSetName = "NewSample"

        objTable.TableName = "NewTable"

        objTable.Columns.Add("NewColumn", Type.GetType("System.String"))

        objDataSet.Tables.Add(objTable)

        objDataSet.ReadXml(objReader1)

        TextBox1.Text = "DataSet Output:" & CrLf & objDataSet.GetXml

        objDataSet = Nothing

        objXmlDataDocument.Load(objReader2)

        TextBox1.Text &= CrLf & "XmlDataDocument Output:" & CrLf & objXmlDataDocument.OuterXml