Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » XML in the Database » Using XML in the database » Importing XML documents as relational data

 

Importing XML using the DataSet object

The ADO.NET DataSet object allows you to read the data and/or schema from an XML document into a DataSet.

  • The ReadXml method populates a DataSet from an XML document that contains both a schema and data.
  • The ReadXmlSchema method reads only the schema from an XML document. Once the DataSet is filled with data from the XML document, you can update the tables in your database with the changes from the DataSet.

DataSet objects can also be manipulated using the SQL Anywhere ADO.NET data provider.

For information about using a DataSet to read the data and/or schema from an XML document using the SQL Anywhere .NET data provider, see Getting data using the SADataAdapter object.