One other possibility... Does your data contain some non-readable character? (Like those below x20), this could also mess the XML Reader.
2010/11/25 hanks2000 <[email protected]> > Yeah the data is clean. > > The problem i'm having is you can't view an XMLReader in the locals, I > have to parse it first, and this is where the problem is occurring > > On Nov 25, 4:32 pm, Processor Devil <[email protected]> wrote: > > In both visual studio and Sharp Develop there is a panel called "Local > > Variables", where you can check content of the variables during the > > breakpoint, paused run or simply when some exception occurs (if you are > not > > catching it already). > > Another problem could be if your data resembles xml tags. Are you sure > your > > data doesn't containg "<" or ">" that could make the mess? > > > > 2010/11/25 hanks2000 <[email protected]> > > > > > > > > > Can you tell me how i can do that please? That would be useful > > > > > On Nov 25, 4:18 pm, Processor Devil <[email protected]> wrote: > > > > Well, use debugger and see what's inside > > > > > > 2010/11/25 hanks2000 <[email protected]> > > > > > > > Another possibility I'm considering. Is there a limit to the size > of > > > > > XMLReader? Maybe its getting full and chopping off part of the > > > > > document > > > > > > > On Nov 25, 3:48 pm, hanks2000 <[email protected]> wrote: > > > > > > No, I have matching tags. As I say, it works with a small amount > of > > > > > > text in between the tags, as soon as the content is rather large > (700 > > > > > > chars +) I get the above exception. > > > > > > > > Its as if the reader is assuming that the tags arent closed > because > > > of > > > > > > the large string after the opening tag > > > > > > > > On Nov 25, 3:30 pm, Processor Devil <[email protected]> > > > wrote: > > > > > > > > > Well, isn't the problem that you have some unmatched pair tags? > > > > > According to > > > > > > > the exception it looks like some <xmltag> doesn't have a > </xmltag> > > > or > > > > > you > > > > > > > are not using <standalongtag /> for non-pair tags :) > > > > > > > > > 2010/11/25 hanks2000 <[email protected]> > > > > > > > > > > Hi Guys > > > > > > > > > > I'm fetching data using an SQL stored procedure and returning > XML > > > > > > > > using FOR XML EXPLICIT. > > > > > > > > > > In my code I'm then using ExecuteXMLReader on my sql command > to > > > pull > > > > > > > > the data into an XMLReader. > > > > > > > > > > When I try parsing the XMLReader, loading into an XMLDocument > etc > > > I > > > > > > > > get the following exception when the contents of some > elements > > > are > > > > > > > > rather long (approx 700 chars inc spaces) > > > > > > > > > > System.Xml.XmlException: Unexpected end of file has occurred. > The > > > > > > > > following elements are not closed: > > > > > > > > > > If I reduce the contents of the XML elements drastically > > > everthing > > > > > > > > works fine. > > > > > > > > > > Is there a known limit on Element contents when using > XMLReader > > > that > > > > > > > > makes it think the element tags havent been closed? > > > > > > > > > > Thank You In Advance > > > > > > > > > > Hanks > > > > > > > > > > p.s. If I read the results into a string using an > SQLDataReader > > > > > > > > everything works fine- Hide quoted text - > > > > > > > > > - Show quoted text -- Hide quoted text - > > > > > > > > - Show quoted text -- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text -
