Getting Started With XML - Download and readme notes

Click here to download sample code

Destination folder

This zip file is designed to be expanded into a folder called c:\exexml. Feel free to change this as necessary but you will need to alter the path references within the cmdXmlReload_Click and the cmdAdoReload_Click routines accordingly.

Need to change ADO Connection definition

The connection string in cmdSaveData is set to

driver={SQL Server};server=GALILEO;database=NorthWind

which includes the name of my server. You will need to change this as necessary. If you don't have SQL Server then use NorthWind.mdb that ships with MS Access.

Shippers.txt file

The XML data that I saved from my own call to adoRecordSet.Save is stored in the file called shippers.txt. The reason for the extension change from .xml is so that it will not get overwritten if you run the "Create XML Data From RecordSet" button. This file is different in that the ADO routine adds a few extended characters into the resulting file which are perfectly legal but aren't much of an aide to readability. The shippers.txt file is the same file but tidied up, indented, and so on.

Usage

I suggest that you experiment with the code. The XML stuff isn't as elegant as it could be, but I think it is better at clarifying what is actually going than code that is optimised for efficiency. You will see that the XML data is navigated in two different ways in cmdXmlReload_Click