Opening an XML Recordset in ADO.Net?

[Jim Bancroft]

Hi everyone,

I was wondering: does ADO.Net have any methods for opening/reading ADO
recordsets that have been persisted to XML? The ideal for me would be to
open the contents of an XML recordset (that's been persisted to disk) in a
DataTable of some sort. Thanks for pointing me in the right direction.

-Jim

 

[Val Mazur]

Hi Jim,

Since ADO keeps recordset in a *ugly* XML format, you will get same *ugly*
DataSet if you load this XML directly. What you could do is to open XML
using ADO and load this ADO recordset into DataSet
Next links should be useful for you

http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/adorstodataset.aspx

http://support.microsoft.com/default.aspx?scid=kb;en-us;316337&Product=adonet

 

[Jim Bancroft]

These links are great-- thanks Val!

-Jim

Hi Jim,

Since ADO keeps recordset in a *ugly* XML format, you will get same *ugly*
DataSet if you load this XML directly. What you could do is to open XML
using ADO and load this ADO recordset into DataSet
Next links should be useful for you

http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/adorstodataset.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;316337&Product=adonet