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.