InfoPath 2010 - Save to Database (Web Service) - InfoPath Dev
in

InfoPath Dev

InfoPath 2010 - Save to Database (Web Service)

Last post 10-01-2012 02:53 AM by James89. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 10-01-2012 02:53 AM

    InfoPath 2010 - Save to Database (Web Service)

    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

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.