Last post May 14, 2015 10:49 PM by cts-gcrdsd
May 11, 2015 03:01 PM|jjmonty|LINK
I am upgrading an old-school application that uses an ADODB.Recordset to produce an xml with this attribute "ADODB.PersistFormatEnum.adPersistXML":
The xml it creates is a little weird looking to me as it has a schema and some tags I do not recognize like "<rs:data>"; "<rs:insert>"; "<z:row>".
I would like to remove the ADODB reference all together and construct the xml with the native .Net methods. The problem is that the format of the ADODB-formated xml must be preserved because I do not have access to the code that consumes the xml.
Is there a way I can format the xml with native .NET in the exact same way that the ADODB object does??
May 14, 2015 10:49 PM|cts-gcrdsd|LINK
I'm not sure how the application works, and what you are trying to do now.
Now that you says "the ADODB-formated xml must be preserved", a simple method is to import the ADODB-formated xml into an Excel workbook, and then export it as a new xml file.
If this is what you want, you can find the solution and a demo from the following site: