Create an XML schema form a DataSet

Mukesh Kumar
14y
13.5k
0
0
25
Blog

Create an XML schema form a DataSet

You can store the schema definition with data from a DataSet within XML file by passing XmlWriteMode.WriteSchema as the second parameter of the WriteXml method of DataSet. XmlWriteMode enumeration specifies how to write XML data and a relational schema from a DataSet.

The following code shows how generates the schema definition within the XML file

string strFileName = @"..\..\Customer.xml";

string strConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";

string strText = "SELECT Top 2 * FROM Sales.Customer Order By ModifiedDate Desc";

// Create and fill a DataSet using a data adapter

SqlDataAdapter objDataAdapter = new SqlDataAdapter(strText, strConnectString);

DataSet objDataSet = new DataSet("CustomerData");

// Fill DataSet with customer record

objDataAdapter.Fill(objDataSet,"Customer");

// Write the xml schema for the DataSet

objDataSet.WriteXml(strFileName, XmlWriteMode.WriteSchema);

The resulting XML schema file contents will look like this :

<?xml version="1.0" standalone="yes"?>

<xs:schema id="CustomerData" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<xs:element name="CustomerData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="Customer">

<xs:complexType>

<xs:sequence>

<xs:element name="CustomerID" type="xs:int" minOccurs="0" />

<xs:element name="TerritoryID" type="xs:int" minOccurs="0" />

<xs:element name="AccountNumber" type="xs:string" minOccurs="0" />

<xs:element name="CustomerType" type="xs:string" minOccurs="0" />

<xs:element name="rowguid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" />

<xs:element name="ModifiedDate" type="xs:dateTime" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>

</Customer>

</Customer>

</CustomerData>