Contents Index Exporting relational data as XML from Interactive SQL Importing XML documents as relational data

ASA SQL User's Guide
  Using XML in the Database
    Exporting relational data as XML

Exporting relational data as XML using the DataSet object


The ADO.NET DataSet object allows you to save the contents of the DataSet in an XML document. Once you have filled the DataSet (for example, with the results of a query on your database) you can save either the schema or both the schema and data from the DataSet in an XML file. The WriteXml method saves both the schema and data in an XML file, while the WriteXmlSchema method saves only the schema in an XML file. You can fill a DataSet object using the Adaptive Server Anywhere ADO.NET data provider.

For information about exporting relational data as XML using a DataSet, see Inserting, updating, and deleting rows using the AsaCommand object.


Contents Index Exporting relational data as XML from Interactive SQL Importing XML documents as relational data