title: XML Special Character Handling
body: <p>VB / C# im attempting to parse the XML file which contains the special character, </p>
  
  <pre><code>replace &amp; with &amp;amp
  ' with &amp;apos
  &lt; with &amp;lt
  &gt; with &amp;gt
  </code></pre>
  
  <p>the string replace did not as it replaces the special character '&lt;' , '>' in the the tags.
  i tried with catch XML exceptions that didn't work when there are multiple special characters in same line, it works if only one special character in a line.
  the MS builtin method SecurityElement.Escape didn't work, this has to be done before the XML tags are attached.</p>
  
  <p>im using this file to load a SQL table.</p>
  
  <p>Any other solution to handle the XML multiple special characters?</p>