tags:

views:

579

answers:

4

I have an XML file begining like this:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"&gt;
  <DataSources>

When I run following code:

byte[] fileContent = //gets bytes
            string stringContent = Encoding.UTF8.GetString(fileContent);
            XDocument xml = XDocument.Parse(stringContent);

I get following XmlException:

Data at the root level is invalid. Line 1, position 1.

Cutting out the version and encoding node fixes the problem. Why? How to process this xml correctly?

+6  A: 

Do you have a byte-order-mark (BOM) at the beginning of your XML, and does it match your encoding ? If you chop out your header, you'll also chop out the BOM and if that is incorrect, then subsequent parsing may work.

You may need to inspect your document at the byte level to see the BOM.

Brian Agnew
what is a byte-order-mark...? and how can I find out document's encoding? I just suspect it is utf-8 (read text is readable)
agnieszka
See the link I posted. It's a sequence of bytes *before* the header that acts as a directive to the encoding of the document.
Brian Agnew
+4  A: 

Why bothering to read the file as a byte sequence and then converting it to string while it is an xml file? Just leave the framework do the loading for you and cope with the encodings:

var xml = XDocument.Load("test.xml");
Darin Dimitrov
Because I don't get the xml from a path. I just have bytes content
agnieszka
And where are those bytes coming from? Database, network stream, ...?
Darin Dimitrov
List on a Sharepoint. It is called item.File.OpenBinary()
agnieszka
+4  A: 

My first thought was that the encoding is Unicode when parsing XML from a .NET string type. It seems, though that XDocument's parsing is quite forgiving with respect to this.

The problem is actually related to the UTF8 pre-amble, which is a three byte signature optionally present at the start of a UTF-8 streams. These three bytes are a hint as to the encoding being used in the stream.

You can determine the pre-amble of an encoding by calling the GetPreamble method on an instance of the System.Text.Encoding class. For example:

// returns { 0xEF, 0xBB, 0xBF }
byte[] preamble = Encoding.UTF8.GetPreamble();

The preamble/BOM should be handled correctly by XmlTextReader, so load your XDocument from an XmlTextReader:

XDocument xml;
using (var xmlStream = new MemoryStream(fileContent))
using (var xmlReader = new XmlTextReader(xmlStream))
{
    xml = XDocument.Load(xmlReader);
}
Dave Cluderay
Note that the UTF-8 ‘pre-amble’ is a Microsoft invention that is not endorsed by any Unicode standard, unlike the normal UTF-16 BOMs. It should never be used on writing, though you will have to handle it on reading as you will often meet the pesky blighter in the wild.
bobince
@bobince - I agree (although it is allowed for by the Unicode standard, but its use is discouraged - see page 36 of http://www.unicode.org/versions/Unicode5.0.0/ch02.pdf#G19273 for more information).
Dave Cluderay
ok but how to process this xml correctly?
agnieszka
I've amended the answer - see the last paragraph.
Dave Cluderay
A: 

If you only have bytes you could either load the bytes into a stream:

XmlDocument oXML;

using (MemoryStream oStream = new MemoryStream(oBytes))
{
  oXML = new XmlDocument();
  oXML.Load(oStream);
}

Or you could convert the bytes into a string (presuming that you know the encoding) before loading the XML:

string sXml;
XmlDocument oXml;

sXml = Encoding.UTF8.GetString(oBytes);
oXml = new XmlDocument();
oXml.LoadXml(sXml);

I've shown my example as .NET 2.0 compatible, if you're using .NET 3.5 you can use XDocument instead of XmlDocument.

Load the bytes into a stream:

XDocument oXML;

using (MemoryStream oStream = new MemoryStream(oBytes))
using (XmlTextReader oReader = new XmlTextReader(oStream))
{
  oXML = XDocument.Load(oReader);
}

Convert the bytes into a string:

string sXml;
XDocument oXml;

sXml = Encoding.UTF8.GetString(oBytes);
oXml = XDocument.Parse(sXml);
Stevo3000
the problem is I need to use XDocument
agnieszka
@agnieszka - I've updated my answer to walk you through how to use the XDocument.
Stevo3000
i ended up doing this actually ;) thanks anyway
agnieszka