Save Recordsets To/Load Recordsets From XML Files Using ADO 2.5
Category:
ASP, HTML and XMLType:
SnippetsDifficulty:
BeginningAuthor:
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: