Click here to Skip to main content
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 OriginalGriff 210
1 Richard MacCutchan 100
2 kbrandwijk 100
3 ProgramFOX 80
4 Mukesh Bhagat 65
0 Sergey Alexandrovich Kryukov 9,050
1 OriginalGriff 8,151
2 CPallini 2,613
3 Richard MacCutchan 2,221
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web04 | 2.8.140827.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2014
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