Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing data from a VFP app to a .NET web service
Message
Information générale
Forum:
ASP.NET
Catégorie:
Web Services
Titre:
Passing data from a VFP app to a .NET web service
Divers
Thread ID:
00870973
Message ID:
00870973
Vues:
69
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform