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

santhoshp — Mon, 01 Dec 2008 05:38:25 GMT

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.

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

swapna_l9 — Mon, 01 Dec 2008 05:15:40 GMT

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?.

Data Connections

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

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