XML to ADO Recordset

Results 1 to 3 of 3

Thread: XML to ADO Recordset

  1. #1
    Join Date
    Dec 1969

    Default XML to ADO Recordset

    Hello,<BR><BR>Can anybody let me know how to convert XML into ADO recordset please.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default why?

    you&#039;re better off using XSL to present the XML...it will scale alot better than creating an ADO recordsset.

  3. #3
    Join Date
    Dec 1969

    Default RE: why?

    Probably the data has been returned via an ADO Recordset and therefore the user wants to convert to XML to send the dataset to the browser.<BR><BR>So with your Recordset named oRS do this:<BR><BR> Dim oXML As New DOMDocument<BR> <BR> oRS.Save oXML, adPersistXML<BR><BR>then you can return oXML.xml to the browser or wherever.<BR><BR>Regards<BR>Simon<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts