Baffling READXML problem

[bfrasca]

I have a well-formed XML file that I am trying to load into a dataset
using the ReadXML method. It keeps telling me that "there are multiple
root elements". I can view the data using XML Designer in Visual
Studio 2003 without any problems and the schema and file have been
validated using several different tools. I even successfully generated
a typed dataset with Visual Studio 2003 by importing the XML into my
project. I'm baffled, does anyone have any thoughts?

This is the latest version. I've tried it using various xmlReadModes
and without the ReadXmlSchema call but I get the same exception every
time.

Dim y As New DataSet

Dim xmlPath as String = "..\01.xml"

Dim xmlFileStream As New FileStream(xmlPath, FileMode.Open)

Dim xmlTextReader As New XmlTextReader(xmlFileStream)

Try
y.ReadXmlSchema("..\01.xsd")
y.ReadXml(xmlFileStream, XmlReadMode.IgnoreSchema)

Catch ex As Exception
Throw ex

End Try

[Yingzi Le]

HI,

You need to add DataTable for the DataSet and Columns for the DataTable the same time.

MSDN site has really good topic with sample code showing you how to accomplish this:

http://msdn.microsoft.com/library/en...asp?frame=true

-- Yingzi

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------

From: "bf*****@comcast.net" <bf*****@comcast.net>
Newsgroups: microsoft.public.dotnet.xml
Subject: Baffling READXML problem
Date: 19 Oct 2005 09:39:27 -0700
Organization: http://groups.google.com
Lines: 29
Message-ID: <11**********************@g43g2000cwa.googlegroups .com>
NNTP-Posting-Host: 146.243.4.157
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1129739980 7411 127.0.0.1 (19 Oct 2005 16:39:40 GMT)
X-Complaints-To: gr**********@google.com
NNTP-Posting-Date: Wed, 19 Oct 2005 16:39:40 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 proxysv03.jud.state.ma.us:3128 (Squid/2.4.STABLE6)
Complaints-To: gr**********@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=146.243.4.157;
posting-account=KjtniQ0AAAAnunjTbEKn-UFEdcuIddxr
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfee d00.sul.t-online.de!t-online.de!news.glorb.com!postnews.google.com! g43g2000cwa.googlegroups.com!not-for-mailXref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.xml:8985
X-Tomcat-NG: microsoft.public.dotnet.xml

I have a well-formed XML file that I am trying to load into a dataset
using the ReadXML method. It keeps telling me that "there are multiple
root elements". I can view the data using XML Designer in Visual
Studio 2003 without any problems and the schema and file have been
validated using several different tools. I even successfully generated
a typed dataset with Visual Studio 2003 by importing the XML into my
project. I'm baffled, does anyone have any thoughts?

This is the latest version. I've tried it using various xmlReadModes
and without the ReadXmlSchema call but I get the same exception every
time.

Dim y As New DataSet

Dim xmlPath as String = "..\01.xml"

Dim xmlFileStream As New FileStream(xmlPath, FileMode.Open)

Dim xmlTextReader As New XmlTextReader(xmlFileStream)

Try
y.ReadXmlSchema("..\01.xsd")
y.ReadXml(xmlFileStream, XmlReadMode.IgnoreSchema)

Catch ex As Exception
Throw ex

End Try

[Bobaloo]

Thanks but that example is in the regular documentation. The only
reason the data table and columns were created was in order to write
out an xml file so it could subsequently read it back in.
Additionally, the "Original" data set is not a typed dataset. The
example doesn't really address my problem, i.e. I don't know the size
and shape of the XML, (that's why I'm reading the XML schema) and I
want to place it in a typed dataset.