I am currently trying to store information from an InfoPath (2010) form into a database. I am using an web service built in Vb.net (I have to use VB).
I am currently submitting the entrie form in XML, and then reading in the values, and submitting it to the database.
The problem I have currerntly is that I can't retrieve the XML in VB.net from infopath form.
So far I have the following code, but when I do a count on the list it returns nothing
Public Sub XMLReaderVacancies(doc As XmlDocument)
Dim nsManager As New XmlNamespaceManager(doc.NameTable)
nsManager.AddNamespace("dfs", "http://schemas.microsoft.com/office/infopath/2003/dataFormSolution")
Dim root As XmlNode = doc.DocumentElement
Dim list As XmlNodeList = root.SelectNodes("/dfs:myFields", nsManager)
Dim array As New ArrayList
'database.InsertIntoDatabase(array, "vacancies")
'Get the XML'
'Get Array of results'
'Insert into database. -- Complete'
End Sub
Does anyone have any ideas on how to read in the XML from InfoPath?
Thanks you
James