how does the webservice look like?

[steve]

hi,

I'm testing the best work way to use infopath, webservices, sqlserver,
sharepoint.

scenario;
submitting the infopath data to the webservice, the webservice saves the
data to sql
te form get published on the sharepoint server.

I'm currently reading the WebServiceConnection.Execute Method
(XPathNavigator, XPathNavigator, XPathNavigator) from the msdn site.

http://msdn2.microsoft.com/en-us/library/aa943097(VS.80).aspx

I'm new to webservice's does someone now how the webservice looks like with
the method WebServiceConnection.Execute?

------------------------------------------------

Now i'm using the example but it does not give me the flexibility im looking
for
http://blogs.msdn.com/philoj/archive/2005/11/08/490200.aspx
I need to get an result back to the form as I ask in my previous question.

http://www.microsoft.com/communitie...&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us

 

[Clay Fox]

Hi Steve.

You may want to look at the Database Accelerator at http://www.qdabra.com.
It has all of the webservices you need already packaged up and installable to
let you query and submit to SQL.

With it I have done many similar solutions to what you are proposing.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[BobCh]

I suggest you try calling web services via the Data Connection path.
I have some quite complex processes that use this approach and it
works well.

I have a webservice with the following string args,

Public Function Contact_IU_from_XML(ByVal aContactXML As String,
ByVal aIndustriesXML As String, ByVal asInterestsXML As String, ByVal
asContactCategoryXML As String) As Integer

and in the Data Connection wizard I have
Field or group: /ns3:myFields
Submit data as a string.

In the service I create an xmlreader from the fragment and the known
schema (pulled from the infopath xsn file).

hth.