XmlReader and XML Web Control

[Jeff]

Hi

I am trying to use the XML Web Control and the XmlReade
but when I try and load the xmlReader into the XmlDocument is gives me this erro

Error: This document already has a DocumentElement node
It fails at: doc.Load(myXmlReader

Is there something I am missing

Here is my code

Dim myCommand As SqlCommand = New SqlCommand("Select proddesc from invli where custid = '1STRFA' for xml auto", myConnection
myConnection.Open(

Dim myXmlReader As System.Xml.XmlReader = myCommand.ExecuteXmlReader(

Dim doc As XmlDocument = New XmlDocumen
doc.Load(myXmlReader

Dim trans As XslTransform = New XslTransfor
trans.Load(Server.MapPath("ProductTable.xsl")

Xml1.Document = do
Xml1.Transform = tran

Thank
Jeff

[Oleg Tkachenko [MVP]]

Jeff wrote:

I am trying to use the XML Web Control and the XmlReader
but when I try and load the xmlReader into the XmlDocument is gives me this error

Error: This document already has a DocumentElement node.
It fails at: doc.Load(myXmlReader) Dim myXmlReader As System.Xml.XmlReader = myCommand.ExecuteXmlReader()

Most likely, this command returns XML with more than one root element,
such as
<Customers>
....
</Customers>
<Customers>
....
</Customers>

Such XML fragment cannot be loaded into XmlDocument.
You could use SqlXmlCommand instead of SqlCommand - former allows to
generate single rooted result (via RootTag property).
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com