I would like to know how to do the following...
The application is in Winforms, .NET 3.5 using C#.
There is an html location (not web service) that I can open and that returns multiple records in XML format (see attached).
How can I access this location from Winforms, loop through the records and store them in a defined database table where the table elements match the XML child nodes.
I am familiar on how to do it with Web Services and the WSDL class converter but have never programmed a situation like this.
If there is an alternative to do this directly in a SQL Server stored procedure, I would like to know how to do that.
<description>The luxurious Crown Towers sets the benchmark for luxury hotels in Australia.</description>
<address line1="8 Whiteman Street" line2="Southbank, VIC 3006" line3="AUSTRALIA"/>