how to retrive data and insert into database by using infopath? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

how to retrive data and insert into database by using infopath?

Last post 11-30-2008 09:38 PM by santhoshp. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-30-2008 09:15 PM

    how to retrive data and insert into database by using infopath?

    i am creating Poc(proof of concept in my company).i need to get the data from database and fill it to control and i will enter data other than filling control, i want to save to as xml in database.

    like contactdetail,i will take the data from database contact details, i will enter extra course detail and i will send database. how to do it?. for poc i don't want to use dbxl.please tell me how do it?.

  • 11-30-2008 09:38 PM In reply to

    Re: how to retrive data and insert into database by using infopath?

    Hi,

    You have to use webservice to save the xml in database. You can create a http end point web service in SQL. 

    Here 'infocityhall.dbo.submit' is a stored procedure which inserts data into a table.

    --Create a web service by using the stored procedure to submit data

    Create ENDPOINT discount_endpoint_Receive

    STATE = STARTED AS HTTP (PATH = '/sqlsubmit',

    AUTHENTICATION = (INTEGRATED ),

    PORTS = ( CLEAR ),

    SITE = 'server14') FOR SOAP (WEBMETHOD 'SubmitData'

    (name='infocityhall.dbo.submit',SCHEMA=STANDARD ),

    WSDL = DEFAULT,

    SCHEMA = STANDARD,

    DATABASE = 'infocityhall',

    NAMESPACE = 'http://tempUri.org/')

     

    Now you have to take receive data connection for "SubmitData" method in "http://server14/sqlsubmit?WSDL" web service.

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