InfoPath Dev

Hi

I created one browser enabled IPF, it contains 5 textfields (Name,Class,Subject,ID,Date).

I created one database in my sql server.

How can i receive sql data from my IPF using webservice.

If anyone knows the solution give me some examples.

Hi jeeva,

can you go through the below links, I hope it gives clear idea

http://blogs.technet.com/elenat/archive/2008/05/13/designing-an-infopath-form-that-can-store-data-in-a-database-part1.aspx

http://blogs.technet.com/elenat/archive/2008/05/13/designing-an-infopath-form-that-can-store-data-in-a-database-part2.aspx

http://blogs.technet.com/elenat/archive/2008/05/13/designing-an-infopath-form-that-can-store-data-in-a-database-part3.aspx

Hi, 

You should have a method in your web service to receive data from database. Then you have to take the receive data connection in your IPF to that web method.

Here is one example for creating a http endpoint web service which has a web method to receive data from a table in database.

select * from dbo.DISCOUNTS

STATE = STARTED

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'server14')

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

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'infocityhall',

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

Now we have to take receive data connection for "ReceiveData" method in "http://server14/sqlreceive?WSDL" web service.

 Hi Friends,

Thank u very much for yours solution.

I solve my issue by changing the cross-domain property in central admin.