InfoPath 2010 - Save to Database (Web Service)

James89 — Mon, 01 Oct 2012 09:53:30 GMT

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

Web Services

InfoPath 2010 - Save to Database (Web Service)