.NET Framework Class Library
DataSet..::.ReadXml Method (String)

Reads XML schema and data into the DataSet using the specified file.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)
Syntax

Visual Basic (Declaration)
Public Function ReadXml ( _
    fileName As String _
) As XmlReadMode
Visual Basic (Usage)
Dim instance As DataSet
Dim fileName As String
Dim returnValue As XmlReadMode

returnValue = instance.ReadXml(fileName)
C#
public XmlReadMode ReadXml(
    string fileName
)
Visual C++
public:
XmlReadMode ReadXml(
    String^ fileName
)
JScript
public function ReadXml(
    fileName : String
) : XmlReadMode

Parameters

fileName
Type: System..::.String
The filename (including the path) from which to read.

Return Value

Type: System.Data..::.XmlReadMode
The XmlReadMode used to read the data.
Exceptions

ExceptionCondition
SecurityException

FileIOPermission is not set to Read.

Remarks

The ReadXml method provides a way to read either data only, or both data and schema into a DataSet from an XML document, whereas the ReadXmlSchema method reads only the schema. To read both data and schema, use one of the ReadXML overloads that includes the mode parameter, and set its value to ReadSchema.

Note that the same is true for the WriteXml and WriteXmlSchema methods, respectively. To write XML data, or both schema and data from the DataSet, use the WriteXml method. To write just the schema, use the WriteXmlSchema method.

If an in-line schema is specified, the in-line schema is used to extend the existing relational structure prior to loading the data. If there are any conflicts (for example, the same column in the same table defined with different data types) an exception is raised.

If no in-line schema is specified, the relational structure is extended through inference, as necessary, according to the structure of the XML document. If the schema cannot be extended through inference in order to expose all data, an exception is raised.

NoteNote:

The DataSet does not associate an XML elementwith its corresponding DataColumn or DataTable when legal XML characters like ("_") are escaped in the serialized XML. The DataSet itself only escapes illegal XML characters in XML element names and hence can only consume the same. When legal characters in XML element name are escaped, the element is ignored while processing.

If the XML Schema for a DataSet includes a targetNamespace, data may not be read, and you may encounter exceptions when calling ReadXml to load the DataSet with XML that contains elements with no qualifying namespace. To read unqualified elements, set elementFormDefault equal to "qualified" in your XML Schema as the following example demonstrates.

 <xsd:schema id="MyDataSet" 
    elementFormDefault="qualified" 
    targetNamespace="http://www.tempuri.org/MyDataSet.xsd" 
    xmlns="http://www.tempuri.org/MyDataSet.xsd" 
    xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
    xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 </xsd:schema>
NoteNote:

If the schema for your DataSet contains elements of the same name, but different type, in the same namespace, an exception is thrown when you attempt to read the schema into the DataSet with ReadXml by specifying XmlReadMode.ReadSchema. This exception does not occur if you are using .NET Framework version 1.0.

Examples

The following example first creates a simple DataSet with one DataTable, two columns, and ten rows. The DataSet schema and data are written to disk by invoking the WriteXml method. A second DataSet is created and the ReadXml method is used to fill it with schema and data.

Visual Basic
Private Sub DemonstrateReadWriteXMLDocumentWithStreamReader()
    ' Create a DataSet with one table and two columns.
    Dim OriginalDataSet As New DataSet("dataSet")
    OriginalDataSet.Namespace = "NetFrameWork"
    Dim table As New DataTable("table")
    Dim idColumn As New DataColumn("id", _
        Type.GetType("System.Int32"))
    idColumn.AutoIncrement = True

    Dim itemColumn As New DataColumn("item")
    table.Columns.Add(idColumn)
    table.Columns.Add(itemColumn)
    OriginalDataSet.Tables.Add(table)

    ' Add ten rows.
    Dim newRow As DataRow
    Dim i As Integer
    For i = 0 To 9
        newRow = table.NewRow()
        newRow("item") = "item " & i.ToString()
        table.Rows.Add(newRow)
    Next i
    OriginalDataSet.AcceptChanges()

    ' Print out values of each table in the DataSet 
    ' using the function defined below.
    PrintValues(OriginalDataSet, "Original DataSet")

    ' Write the schema and data to an XML file.
    Dim xmlFilename As String = "XmlDocument.xml"

    ' Use WriteXml to write the document.
    OriginalDataSet.WriteXml(xmlFilename)

    ' Dispose of the original DataSet.
    OriginalDataSet.Dispose()

    ' Create a new DataSet.
    Dim newDataSet As New DataSet("New DataSet")

    ' Read the XML document into the DataSet.
    newDataSet.ReadXml(xmlFilename)

    ' Print out values of each table in the DataSet 
    ' using the function defined below.
    PrintValues(newDataSet, "New DataSet")
End Sub

Private Sub PrintValues(dataSet As DataSet, label As String)
    Console.WriteLine(ControlChars.Cr & label)
    Dim table As DataTable
    For Each table In  dataSet.Tables
        Console.WriteLine("TableName: " & table.TableName)
        Dim row As DataRow
        For Each row In  table.Rows
            Dim column As DataColumn
            For Each column In  table.Columns
                Console.Write(ControlChars.Tab & " " & _
                    row(column).ToString())
            Next column
            Console.WriteLine()
        Next row
    Next table
End Sub
C#
private void DemonstrateReadWriteXMLDocumentWithStreamReader()
{
    // Create a DataSet with one table and two columns.
    DataSet OriginalDataSet = new DataSet("dataSet");
    OriginalDataSet.Namespace= "NetFrameWork";
    DataTable table = new DataTable("table");
    DataColumn idColumn = new DataColumn("id", 
        Type.GetType("System.Int32"));
    idColumn.AutoIncrement= true;

    DataColumn itemColumn = new DataColumn("item");
    table.Columns.Add(idColumn);
    table.Columns.Add(itemColumn);
    OriginalDataSet.Tables.Add(table);

    // Add ten rows.
    DataRow newRow;
    for(int i = 0; i < 10; i++)
    {
        newRow = table.NewRow();
        newRow["item"]= "item " + i;
        table.Rows.Add(newRow);
    }
    OriginalDataSet.AcceptChanges();

    // Print out values of each table in the DataSet 
    // using the function defined below.
    PrintValues(OriginalDataSet, "Original DataSet");

    // Write the schema and data to an XML file.
    string xmlFilename = "XmlDocument.xml";

    // Use WriteXml to write the document.
    OriginalDataSet.WriteXml(xmlFilename);

    // Dispose of the original DataSet.
    OriginalDataSet.Dispose();

    // Create a new DataSet.
    DataSet newDataSet = new DataSet("New DataSet");

    // Read the XML document into the DataSet.
    newDataSet.ReadXml(xmlFilename);

    // Print out values of each table in the DataSet 
    // using the function defined below.
    PrintValues(newDataSet,"New DataSet");
}

private void PrintValues(DataSet dataSet, string label)
{
    Console.WriteLine("\n" + label);
    foreach(DataTable table in dataSet.Tables)
    {
        Console.WriteLine("TableName: " + table.TableName);
        foreach(DataRow row in table.Rows)
        {
            foreach(DataColumn column in table.Columns)
            {
                Console.Write("\table " + row[column] );
            }
            Console.WriteLine();
        }
    }
}
.NET Framework Security

Platforms

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360, Zune

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 3.5, 2.0, 1.0

XNA Framework

Supported in: 3.0, 2.0, 1.0
See Also

Reference

Other Resources

Tags :


Community Content

dotBomb
Augmented Example Code to Allow for Before/After DataColumn Type Comparison

class

ReadWriteXmlExample

{

staticvoid Main(string[] args)

{

DemonstrateReadWriteXMLDocumentWithStreamReader();

}

privatestaticvoid DemonstrateReadWriteXMLDocumentWithStreamReader()

{

// type variables defined for type comparison

//

Type i32Type = Type.GetType("System.Int32");

Type sType = Type.GetType("System.String");

// Create a DataSet with one table and two columns.

DataSet OriginalDataSet = newDataSet("dataSet");

OriginalDataSet.Namespace =

"NetFrameWork";

DataTable table = newDataTable("table");

DataColumn idColumn = newDataColumn("id", Type.GetType("System.Int32"));

idColumn.AutoIncrement =

true;

DataColumn itemColumn = newDataColumn("item", Type.GetType("System.String"));

table.Columns.Add(idColumn);

table.Columns.Add(itemColumn);

OriginalDataSet.Tables.Add(table);

// Add ten rows.

DataRow newRow;

for (int i = 0; i < 10; i++)

{

newRow = table.NewRow();

newRow[

"item"] = "item " + i;

table.Rows.Add(newRow);

}

OriginalDataSet.AcceptChanges();

// Print out values of each table in the DataSet

// using the function defined below.

PrintValues(OriginalDataSet,

"Original DataSet");

if ((OriginalDataSet.Tables[0].Columns["id"].DataType) == i32Type)

{

Console.WriteLine("ID column types match!");

}

else

{

Console.WriteLine("ID column types *do not* match!");

}

if ((OriginalDataSet.Tables[0].Columns["item"].DataType) == sType)

{

Console.WriteLine("ITEM column types match!");

}

else

{

Console.WriteLine("ITEM column types *do not* match!");

}

Console.ReadLine();

// Write the schema and data to an XML file.

string xmlFilename = "XmlDocument.xml";

// Use WriteXml to write the document.

OriginalDataSet.WriteXml(xmlFilename);

// Dispose of the original DataSet.

OriginalDataSet.Dispose();

// Create a new DataSet.

DataSet newDataSet = newDataSet("New DataSet");

// Read the XML document into the DataSet.

newDataSet.ReadXml(xmlFilename);

if ((newDataSet.Tables[0].Columns["id"].DataType) == i32Type)

{

Console.WriteLine("ID column types match!");

}

else

{

Console.WriteLine("ID column types *do not* match!");

}

if ((newDataSet.Tables[0].Columns["item"].DataType) == sType)

{

Console.WriteLine("ITEM column types match!");

}

else

{

Console.WriteLine("ITEM column types *do not* match!");

}

Console.ReadLine();

// Print out values of each table in the DataSet

// using the function defined below.

PrintValues(newDataSet,

"New DataSet");

Console.ReadLine();

}

privatestaticvoid PrintValues(DataSet dataSet, string label)

{

Console.WriteLine("\n" + label);

foreach (DataTable table in dataSet.Tables)

{

Console.WriteLine("TableName: " + table.TableName);

foreach (DataRow row in table.Rows)

{

foreach (DataColumn column in table.Columns)

{

Console.Write("\tcolumn " + row[column]);

}

Console.WriteLine();

}

}

}

}

Tags :

Page view tracker