OK, so it's just an XML string, that's good. You mentioned in your original post that in your VFP app, you stuck the results in a temp table and did a SCAN in a grid. You can do a similar thing in .NET, but how you get the info into a DataSet/DataTable will depend on the structure of the XML string.
A quick thing to try is this:
DataSet ds = new DataSet();
string XML = this.oWS.GetStuffFromWebService();
this.FillFromXML(ds, XML);
public void FillFromXML(DataSet Data, string XML)
{
StringReader sr = new StringReader(XML);
Data.ReadXml(sr, XmlReadMode.InferSchema);
Data.AcceptChanges();
}
If that doesn't produce anything of value, or just flat out doesn't work, then your XML probably needs to be parsed with the XML DOM, which I haven't really used and so don't know all that much about. But, should be relatively easy to find info on the XmlDocument class (in the System.Xml namespace). In fact, here's a link to get you started:
http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspxHope that helps.
~~Bonnie
>Bonnie,
>A lttle more detail - I send a control number to the web service not knowing what the control number represents. The web service returns a XML string which when parsed tells me what to send next. For example I send the control number and based on that number the web service returns a string that tells me that this job is a repair to a piece of equipment. From this I know that I need to send the data required for a repair. I send the data and tell the web service that a repair was made and it required parts. The web service returns a string acknowledging reciept of that data and requesting information on the part. I return data about the part and the web service returns a reciept and tells me that all required data for this control number is complete. Then I update the SQL Server data base to show that the data has been successfully transfered and start the process on the next control number.
>
>
>>
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.