Click here to Skip to main content
11,711,750 members (78,968 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# database comparison
How do i go about comparing the content of a Database table to that of an XML document. If there are any difference in the XML to whats stored in the table do an update in the table. If no difference is found in the XML then the content in the table will remain the same.

Eg
--XML Document----
<Root>
<Firstname>John</Firstname>
<Surname>Smith</Surname>
</Root>


-- Table----
Firstname|  Surname
---------------------
  John   |  bent


-- Table Changed to --
Firstname|  Surname
---------------------
  John   |  Smith
Posted 19-Nov-12 12:50pm
Comments
Sergey Alexandrovich Kryukov at 19-Nov-12 19:06pm
   
And? Is this a question or what?
--SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 CHill60 280
1 Sergey Alexandrovich Kryukov 264
2 OriginalGriff 170
3 Andy Lanng 160
4 Richard MacCutchan 130
0 CHill60 280
1 Sergey Alexandrovich Kryukov 125
2 Andy Lanng 120
3 Abhinav S 95
4 Maciej Los 95


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100