ADO GetRows array to XML?

rgutter_at_bctf.ca
Date: 02/20/05 

Date: 20 Feb 2005 06:14:49 -0800

I need to pass a few dozen sequential records at a time from a 50K row
recordset to another process (which expects an XML file), and thought I
had the solution: just iterating through this VB-ish pseudocode

  avar(0)=Rs.Bookmark
  Rs.Move n
  avar(1)=Rs.Bookmark
  Rs.Filter = Array(avar(0),avar(1))
  Rs.Save filename.xml,adPersist
  Rs.MoveNext

But it turns out that the filtered Rs gets saved only if the filter is
constructed via a criteria string; bookmarks won't do.

So I'm considering Rs.GetArray(x) instead. But - is there a simple way
to create an XML file from the resultant array?

Thanks.

Relevant Pages

  • Re: How to manage XML streams in DirectShow filters ?
    ... > I know DirectShow is originally built to be used with pictures, videos, ... > which each filter is used to call a specific function (for pattern ... > simple video rendering graph, which is a quite dirty and ugly trick. ... or plain text like in a xml file) to the ...
    (microsoft.public.win32.programmer.directx.video)
  • DataTable.Select problem in ASP.NET 2.0
    ... I have DataSet which reads data from XML file using DataSet.ReadXML. ... it doesnt recognize that parameter and doesnt return the value, ... DataTable has various rows containing data, now when i try to filter ... method works for some criteria and it doesnt work for some criteria. ...
    (microsoft.public.dotnet.framework.adonet)
  • How to manage XML streams in DirectShow filters ?
    ... which each filter is used to call a specific function (for pattern ... simple video rendering graph, which is a quite dirty and ugly trick. ... What I want to do now is to forget about video in the graph, ... or plain text like in a xml file) to the ...
    (microsoft.public.win32.programmer.directx.video)
  • DataTable.Select problem in ASP.NET 2.0
    ... I have DataSet which reads data from XML file using DataSet.ReadXML. ... it doesnt recognize that parameter and doesnt return the value, ... DataTable has various rows containing data, now when i try to filter ... method works for some criteria and it doesnt work for some criteria. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: generating xml file for visio diagram
    ... Write some sort of XSL transformation for the Visio.vdx file to filter ... out all the stuff you don't care about. ... Create a .NET object structure and serialize it. ... I need to generate xml file for shape objects and there connections in ...
    (microsoft.public.visio.developer.vba)