Converting Dataset to Recordset

[Marathoner]

I have read Bill Vaughn's paper on this subject and I have one stumbling
block. Bill wrote his demo in VB.NET. He converts a DataTable to an XML
file. In VB.NET, he dimmed a recordset and used this syntax:

rs.Open(sPathToXMLfile)

When incorporating his code in my C# app, the ADODB.Recordset Open method
takes 5 arguments, all required. VB.NET arguments are, I assume, optional
since they are in square brackets.

The question is, what syntax is used to open an ADODB Recordset from an XML
file in C#?
--
Robert Hill
Senior Programmer/Analyst
Wake Forest Univ Baptist Med Ctr

[Gaspode]

"Marathoner" <Ma********@discussions.microsoft.com> wrote in message news:<BD**********************************@microso ft.com>...

I have read Bill Vaughn's paper on this subject and I have one stumbling
block. Bill wrote his demo in VB.NET. He converts a DataTable to an XML
file. In VB.NET, he dimmed a recordset and used this syntax:

rs.Open(sPathToXMLfile)

When incorporating his code in my C# app, the ADODB.Recordset Open method
takes 5 arguments, all required. VB.NET arguments are, I assume, optional
since they are in square brackets.

The question is, what syntax is used to open an ADODB Recordset from an XML
file in C#?

Please go and have a look here <a
href="http://msmvps.com/gbvb/archive/2004/05/10/6178.aspx">Check
this</a>

[Marathoner]

Thank you for your response. This link was very informative but left me at
the same point as when I originally posted the question. I have an XML
recordset file created from a dataset. Now, how do I open a recordset with
this XML file in C#?

ADODB.Recodset.Open(sXMLfileName); does not work.

A VB6 application is going to consume this recordset.

Robert

"Gaspode" wrote:

"Marathoner" <Ma********@discussions.microsoft.com> wrote in message news:<BD**********************************@microso ft.com>...

I have read Bill Vaughn's paper on this subject and I have one stumbling
block. Bill wrote his demo in VB.NET. He converts a DataTable to an XML
file. In VB.NET, he dimmed a recordset and used this syntax:

rs.Open(sPathToXMLfile)

When incorporating his code in my C# app, the ADODB.Recordset Open method
takes 5 arguments, all required. VB.NET arguments are, I assume, optional
since they are in square brackets.

The question is, what syntax is used to open an ADODB Recordset from an XML
file in C#?

Please go and have a look here <a
href="http://msmvps.com/gbvb/archive/2004/05/10/6178.aspx">Check
this</a>