Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>Background</h2> <p>Although your question does have the encoding set as UTF-16, you don't have the string properly escaped so I wasn't sure if you did, in fact, accurately transpose the string into your question.</p> <p>I ran into the same exception: </p> <blockquote> <p>System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.</p> </blockquote> <p>However, my code looked like this:</p> <pre><code>string xml = "&lt;?xml version=\"1.0\" encoding=\"utf-8\" ?&gt;\n&lt;event&gt;This is a Test&lt;/event&gt;"; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(xml); </code></pre> <h2>The Problem</h2> <p>The problem is that strings are stored internally as UTF-16 in .NET however the encoding specified in the XML document header may be different. E.g.:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; </code></pre> <p>From the MSDN documentation for String <a href="http://msdn.microsoft.com/en-us/library/system.string.aspx" rel="noreferrer">here</a>:</p> <blockquote> <p>Each Unicode character in a string is defined by a Unicode scalar value, also called a Unicode code point or the ordinal (numeric) value of the Unicode character. Each code point is encoded using UTF-16 encoding, and the numeric value of each element of the encoding is represented by a Char object.</p> </blockquote> <p>This means that when you pass XmlDocument.LoadXml() your string with an XML header, it must say the encoding is UTF-16. Otherwise, the actual underlying encoding won't match the encoding reported in the header and will result in an XmlException being thrown.</p> <h2>The Solution</h2> <p>The solution for this problem is to make sure the encoding used in whatever you pass the Load or LoadXml method matches what you say it is in the XML header. In my example above, either change your XML header to state UTF-16 or to encode the input in UTF-8 and use one of the <a href="http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.load.aspx" rel="noreferrer">XmlDocument.Load methods</a>.</p> <p>Below is sample code demonstrating how to use a MemoryStream to build an XmlDocument using a string which defines a UTF-8 encode XML document (but of course, is stored a UTF-16 .NET string).</p> <pre><code>string xml = "&lt;?xml version=\"1.0\" encoding=\"utf-8\" ?&gt;\n&lt;event&gt;This is a Test&lt;/event&gt;"; // Encode the XML string in a UTF-8 byte array byte[] encodedString = Encoding.UTF8.GetBytes(xml); // Put the byte array into a stream and rewind it to the beginning MemoryStream ms = new MemoryStream(encodedString); ms.Flush(); ms.Position = 0; // Build the XmlDocument from the MemorySteam of UTF-8 encoded bytes XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(ms); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POWhy does C# XmlDocument.LoadXml(string) fail when an XML header is included?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMo Patel
    1. USZach Burlingame
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou saved my day :D
      singulars
      1. PO
      1. USSpyros
    2. COdon't forget the ms.close()
      singulars
      1. PO
      1. USZé Carlos
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload