Save Recordsets To/Load Recordsets From XML Files Using ADO 2.5

Category:
ASP, HTML and XML
Type:
Snippets
Difficulty:
Beginning
Author:
Intelligent Solutions Inc.

Version Compatibility:

More information:
These two functions allow you to save recordsets to an XML file and open a recordset from an XML file in ADO 2.5. The recordset's save method writes extended schema information to the XML file; this information is required to open an XML file into a recordset.

For an alternative way to write recordsets to XML files, in which extended schema information is not written and you have more control over XML file's layout, see the class at http://www.freevbcode.com/ShowCode.Asp?ID=312

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: