An error occurred while parsing EntityName. Line1, position 844.

Question

0.00/5 (No votes)

See more:

Hi All,

I have got the following exception from the below code block.

An error occurred while parsing EntityName. Line1, position 844.

I was trying to parse s set of data retrieved from table to a data set.

C#

public DataSet BindMasterData(string xml)
        {
            DataSet ds = null;
            try
            {
                ds = new DataSet();
                TextReader txtReader = new StringReader(xml);
                XmlReader reader = new XmlTextReader(txtReader);
                ds.ReadXml(reader);
            }
            catch (Exception ex)
            {
                return new DataSet();
            }
            return ds;
        }

I have figured out the reason for the exception, but I couldn't solve it. In this particular situation, the string(which is retrieved from DB) contains a special character (&). That causes exception. How I can solve it. Any help on this would be great.

Thanks & Regards
Sebastian

Posted 8-May-14 2:31am

Sebastian T Xavier

Add a Solution

Comments

Sanket Saxena 8-May-14 8:45am

Could you paste the string generated (including & as you said)?

Sebastian T Xavier 9-May-14 2:15am

added the code below & solved it....
if (xml != null)
{
xml = xml.Replace("&", "&");
}

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ZurdoDev · Answer 1 · 2014-05-08T04:35:00

You need to format your xml properly. An & should actually be & So, format the xml properly when you pass it into this function.

If for some reason you cannot control the xml getting passed to you, you can turn off character checking by doing something like this:

C#

string filePath = @"You file dirtest.xml"; XmlReaderSettings xrs = new XmlReaderSettings(); xrs.CheckCharacters = false; using (XmlReader reader = XmlReader.Create(filePath, xrs)) { while (reader.ReadToFollowing("Content")) {} } - See more at: http://www.debugdotnet.com/xmlreader-read-special-unicode-use-xmlreadersettings-checkcharacters.html#sthash.HrQMOFOd.dpuf

http://www.debugdotnet.com/xmlreader-read-special-unicode-use-xmlreadersettings-checkcharacters.html[^]

However, the best option is to send in properly formed xml.