HOW TO: Read XML Data into a DataSet by Using Visual Basic .NET

Article translations Article translations
Article ID: 309702 - View products that this article applies to.
This article was previously published under Q309702
Expand all | Collapse all

On This Page

SUMMARY

This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object.

Requirements

The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:
  • Microsoft Windows 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, or Windows NT 4.0 Server
  • Microsoft Visual Studio .NET
This article assumes that you are familiar with the following topics:
  • Visual Studio .NET
  • ADO.NET fundamentals and syntax
  • XML fundamentals

Description of the Technique

You can use the ReadXml method to read XML schema and data into a DataSet. XML data can be read directly from a file, a Stream object, an XmlWriter object, or a TextWriter object.

You can use one of two sets of overloaded methods for the ReadXml method, depending on your needs. The first set of four overloaded methods takes just one parameter. The second set of four overloaded methods take an additional parameter (XmlReadMode) along with one of the parameters from the first set.

The following list outlines the first set of overloaded methods, which take one parameter:
  • The code to follow uses a specified file to read XML schema and data into the DataSet:
    Overloads Public Sub ReadXml(String)
    					
  • The code to follow uses a specified TextReader to read XML schema and data into the DataSet. TextReader is designed for character input.
    Overloads Public Sub ReadXml(TextReader)
    					
  • The code to follow uses a specified System.IO.Stream to read XML schema and data into the DataSet. The Stream class is designed for byte input and output.
    Overloads Public Sub ReadXml(Stream)
    					
  • The code to follow uses a specified XmlReader to read XML schema and data into the DataSet. This method provides fast, non-cached, forward-only access to XML data that conforms to the World Wide Web Consortium (W3C) XML 1.0 specification and the namespaces in the XML specification.
    Overloads Public Sub ReadXml(XmlReader)
    					
The list to follow outlines the second set of overloaded methods, which take XmlReadMode with one of the above-mentioned parameters. The XmlReadMode enumeration specifies how to read XML data and schema into a DataSet.
  • DiffGram. Reads a DiffGram, and applies changes from the DiffGram to the DataSet.
  • Fragment. Reads XML documents that contain inline XML-Data Reduced (XDR) schema fragments (such as those that are generated when you run FOR XML schemas that include inline XDR schema against an instance of Microsoft SQL Server).
  • IgnoreSchema. Ignores any inline schema and reads data into the existing DataSet schema.
  • InferSchema. Ignores any inline schema, infers schema from the data, and loads the data. If the DataSet already contains a schema, InferSchema extends the current schema by adding columns to tables that exist and by adding new tables if tables do not exist.
  • ReadSchema. Reads any inline schema, and loads the data.
  • Auto. Default. Performs the most appropriate action.

Create Project and Add Code

This example uses a file named MySchema.xml. To create MySchema.xml, follow the steps in the following Microsoft Knowledge Base article:
308064 HOW TO: Persist an ADO.NET DataSet as XML Using Visual Basic .NET
The following code sample demonstrates how to use two of the commonly used overloaded versions of ReadXml. For other examples, refer to MSDN for individual overload topics of this method.
  1. Start Visual Studio .NET.
  2. Create a new Windows Application project in Visual Basic .NET. Form1 is added to the project by default.
  3. Make sure that your project contains a reference to the System.Data namespace, and add a reference to this namespace if it does not.
  4. Place two Button controls and one DataGrid control on Form1. Change the Name property of Button1 to btnReader, and change its Text property to Reader.

    Change the Name property of Button2 to btnFile, and change its Text property to File.
  5. Use the Imports statement on the System, System.Data, and System.Data.SqlClient namespaces so that you are not required to qualify declarations in those namespaces later in your code.
    Imports System
    Imports System.Data
    Imports System.Data.SqlClient
    					
  6. In the Code window, add the following code after the "Windows Form Designer generated code" region:
    Private Sub btnReader_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles btnReader.Click
        Dim myXMLfile As String = "C:\MySchema.xml"
        Dim ds As New DataSet()
        ' Create new FileStream with which to read the schema.
        Dim fsReadXml As New System.IO.FileStream _
            myXMLfile, System.IO.FileMode.Open)
        Try
            ds.ReadXml(fsReadXml)
            DataGrid1.DataSource = ds
            DataGrid1.DataMember = "Cust"
        Catch ex As Exception
            MessageBox.Show(ex.ToString())
        Finally
            fsReadXml.Close()
        End Try
    End Sub
     
    Private Sub btnFile_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles btnFile.Click
        Dim myXMLfile As String = "C:\MySchema.xml"
        Dim ds As New DataSet()
        Try
            ds.ReadXml(myXMLfile)
            DataGrid1.DataSource = ds
            DataGrid1.DataMember = "Cust"
        Catch ex As Exception
            MessageBox.Show(ex.ToString())
        End Try
    End Sub
    					
  7. Modify the path to the XML file (myXMLfile) as appropriate for your environment.
  8. Save your project. On the Debug menu, click Start to run your project.
  9. Click any of the buttons to read the XML data from the specified file. Notice that the XML data appears in the grid.

Additional Notes

  • To read only the XML schema, you can use the ReadXmlSchema method.
  • To get only the XML representation of the data in the DataSet instead of persisting it onto a stream or a file, you can use the GetXml method.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
308064 HOW TO: Persist an ADO.NET DataSet as XML Using Visual Basic .NET
262450 HOWTO: A C++ Sample of ADO Recordset XML Persistence
For more information about ADO.NET objects and syntax, refer to the following Microsoft .NET Framework Software Development Kit (SDK) documentation or MSDN Online:
Accessing Data with ADO.NET
http://msdn2.microsoft.com/en-us/library/e80y5yhx(vs.71).aspx

Properties

Article ID: 309702 - Last Review: May 13, 2007 - Revision: 2.2
APPLIES TO
  • Microsoft ADO.NET (included with the .NET Framework)
  • Microsoft ADO.NET 1.1
  • Microsoft Visual Basic .NET 2002 Standard Edition
  • Microsoft Visual Basic .NET 2003 Standard Edition
Keywords: 
kbhowtomaster kbsqlclient kbsystemdata KB309702

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com