comparing data in SQL with an XML file [modified]

[ONeil Tomlinson]

HI I have a table (ContactDetails) with 2000 records. I have an application receiving an XML file from an external web service. Most time the data received from the web service is similar to the data in my table. Occasionally the data returned from the web service will have few differences. I want to compare the data received from the web service with the data in my local database and generate a xml file (based on the same schema) to send to another application . So how do i go about doing that? Thanks

modified on Thursday, August 28, 2008 12:13 PM

[David Mujica]

I would approach this problem by breaking it down into phases. 1) Read the XML file 2) Fetch data from the database and compare to XML data 3) Write a resulting XML file Below should get you some idea how to loop through an XML file. Imports System.Xml Dim xdTemplate As New XmlDocument Dim xnRoot As XmlNode xdTemplate.Load("c:\temp\FP_TAK.xml") xnRoot = xdTemplate.SelectSingleNode("/myPath/mySub/etc") ' This code show some simple code to loop through an XML file ' you will need to modify this based on your layout, but at least it shows some ' functionality. While (Not (IsNothing(xnRoot)) If (xnRoot.Name = "FSFORMULATPALL") Then If (xnRoot.Item("PARAM_CODE").InnerText = "R.B.D_SOY_ALLERGEN") Then Debug.Print(CStr(i) + ") " + xnRoot.Item("PARAM_CODE").InnerText) xnRoot.Item("PVALUE_LABEL").InnerText = "No" End If End If xnRoot = xnRoot.NextSibling End While xdTemplate.Save("c:\temp\dave.xml")