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.

I think part of the answer to that question depends on how the data is being returned from the web service. Is it an XML string, XML object or something else?

~~Bonnie



>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.