Deserializing a Data Set from XML
You can
easily create a DataSet by deserializing an XML file or stream. When a schema
is not provided, all XML data is treated as string data, so you should first
load the schema if it is in a separate file.
The
following code sample shows how to read the schema file and then load the XML
file in a DataSet.
using System.Data;
using System.Data.SqlClient;
namespace XMLToDataSet
{
class Program
{
static void Main(string[]
args)
{
string
strFileName = @"..\..\Customer.xml";
DataSet
objDataSet = new DataSet();
objDataSet.ReadXmlSchema(strFileName);
objDataSet.ReadXml(strFileName, XmlReadMode.IgnoreSchema);
}
}
}
In this example we have used XmlReadMode.IgnoreSchema , so if the XML
data file contains an XML schema definition, it is ignored. XmlReadMode enumeration Specifies how to
read XML data and a relational schema into a DataSet.
XmlReadMode Enumeration
Members includes Auto, DiffGram, Fragment,
IgnoreSchema, InferSchema, InferTypedSchema, ReadSchema.