Link to home
Start Free TrialLog in
Avatar of Eric Burton
Eric BurtonFlag for United States of America

asked on

Need to read Adobe XML form data into VB.NET Dataset

When user clicks the submit button on an interactive form, the corresponding email sends a xml data form to the intended recipent.  Need best way to interpret the XML form data and import it into a VB.NET dataset table then save the table back to an Oracle database.
Avatar of Karl Heinz Kremer
Karl Heinz Kremer
Flag of United States of America image

If you are already using some server processing of the data, it would make sense to change the forms submission from an email based system to a direct submission to a web server. This way, you can process the XML on the server and do whatever you need to do with it. Going through email just complicates things. If you also need an email as a notification that new data was received, you can also send out an email from your server software, adding the data in a more human readable format than XML. This way, the recipient knowns that John Smith submitted a form, and does not have to parse XML code to find that out.
Avatar of Eric Burton


Hi Karl,

Thanks for the quick response!  

Unfortunately, there is no middle tier server to process the xml data.  There will be an operator to take the xml attachment from the email and manually upload the data into a dataset.

Avatar of Fernando Soto
Hi Eric;

Well then read the XML data into your program and convert it into an XML document then you could use Document objects to fill your DataSet/DataTable.
I like the XMLDocument object, but is there an easier way to do this using the ReadXML/WriteXML methods?
I'am sorry I do not know XML Document Object model well enough to answer. I only started using XML when Linq to XML came out so I never bothered learning it because it was much easier to learn and work with Linq and XDocument. Maybe someone will drop in that may be able to answer your question.
What can you do when the ReadXML method doesn't work?
Avatar of Eric Burton
Eric Burton
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Fastest way to convert the XML data into a readable format for VB.NET