Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing data from a VFP app to a .NET web service
Message
 
To
All
General information
Forum:
ASP.NET
Category:
Web Services
Title:
Passing data from a VFP app to a .NET web service
Miscellaneous
Thread ID:
00870973
Message ID:
00870973
Views:
67
I need to create a VB.NET web service that must be used from a VFP application.
The vfp application must pass a cursor to the web service which update an SQL Table
I would like to know how to pass the data from the VFP app to the .NET web service, and how to put this data into a .NET dataset so I can update the sql server table.
Actually I'm converting the vfp cursor into xml, then sending the xml string to the web service, but here I'm having some trouble.

In the VFP application I have something like:

use table in 0 shared
cursortoxml("table","myxml")
oWS = CREATEOBJECT("MSSOAP.SoapClient")
oWS.MSSoapInit("http://theserver/ws.wsdl")
oWs.UpdateRow(myxml)
release oWs

In the webservice I have a webmethod as following:

WebMethod(Description:="Update row", EnableSession:=False) _
Public Sub UpdateRow(ByVal lcStr As String)

' in this method I'd like to Fill the dataset with the data contained in the lcStr parameter
' and update the SQL-Server table

End Sub

How can I do?
Thanks in advance

Franco
Next
Reply
Map
View

Click here to load this message in the networking platform