Xml

Someone knows (or can give me an example) how to pass a recordset between two tiers (DLLs) using XML. I did it but using ADO Recordsets, and the problem is that I have to have installed ADO in both machines.

Thanks so much for your coments.

You can
a - pass it as a XML obj (using MS XML parser) or stream

or

b - pass it as a string

I guess the question is how the receiving end is gonna process the info, since if you use option

a - then you will need a XML parser on the other end
b - you will need to parse the string your self (code and code and more code)

But If you want to see more about the option 'a', I'll dig in to my archives, and try to come up with a sample.

Just use MSXML parser. All you have to do is load it into a DOM object, and traverse the tree structure from there. MSXML object hiearchy is pretty easy to manipulate and if you need any help, just give a shout back.

Thank you so much for your help. Do you know where I can find an example. I have installed the XML parser and I saw an example of how to read it, but it will be nice to manipulate a Recordset between tiers and send the information as XML. Thanks again.

VB Code:

Dim adoRS AS New ADODB.Recordset
Dim adoStr AS New ADODB.Stream
Dim objXML AS New MSXML2.DOMDocument
 
'Get your Recordset however
 
'Save it to the stream object
Call adoRS.Save(adoStr, adPersistXML)
 
'Now you have the XML extracted from the recordset
'and placed in the stream object
 
Debug.Print adoStr.ReadAll
 
'You can just pass that as a string or load it into a XML
'DOM Document
 
objXML.loadXML(adoStr.ReadAll)
 
'Now you can pass the whole object and the XML has
'been parsed into objects for you