Convert XML persisted ado recordset to dataset

[Sean Bytnar]

Hello all,

I am looking for C# code that will allow me to take an ADO Recordset
previously persisted to a file as XML and convert it to a Dataset. I
have seen some solutions but have yet to make any of them work. Can
someone please help me with functional code?

Thanks,
Sean


ps. Why would Microsoft provide code to convert Datasets to ADO
Recordsets (new tech -> old tech), but not the other way around to
facilitate migration (old tech -> new tech)?

 

[Val Mazur \(MVP\)]

Hi Sean,

If you need to load saved XML directly into DataSet, then you would need to
transform it first to fit it DataSet's structure. Or you could load dataset
from ADO recordset using next example

http://support.microsoft.com/default.aspx?scid=kb;en-us;310349