Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Web service example
Message
From
09/07/2009 18:30:16
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Web service example
Environment versions
Environment:
ASP.NET
Database:
MS SQL Server
Miscellaneous
Thread ID:
01411307
Message ID:
01411307
Views:
95
I need to find information or an example to do the following in .net:
1. Select records from a SQL Server database.
2. Allow the user to select the records for processing.
3. Send the data from these selected records to a web service.
4. Receive the response from the web service and parse the return.
5. Update the SQL Server data based on the response.

I wrote an application in VFP( which I know and love) and one in Cold Fusion( that I don't know much about but the program worked) that did this. Now the customer wants one done in .Net.( where I am an absolute novice). I got as far as connecting to the web service(same service as the VFP and CF). The actual data query shouldn't be much of a problem but I don't know what to do with the results. In VFP(VFP database) I stuck it a temp table put a grid on a form and did a SCAN when the user clicked OK. In CF I was passed a list of the selected keys from a form someone else did and I did a CFquery(Oracle database) and did a CFloop through the data.
I wish I knew at least enough to ask a better question but for now if I could find an example or other information of something along these lines it would really help.
Next
Reply
Map
View

Click here to load this message in the networking platform