How to use the XMLDataReader

Hi,
Does anybody have an example of how to use an XMLDataReader to return a string of XML

Hope you can help

[120 byte] By [shax] at [2008-1-7]

«« Document Map
»» Bullet proof solution: How to access class''s object Return from Web Service

# 1

Can you explain what you're trying to do? The XmlDataReader is meant to build a DataSet out of an XML document, not return XML...

rkimble at 2007-10-2 >

top of Msdn Tech,Visual Basic,Visual Basic Language...

# 2

Hi,
I use FOR XML AUTO, ELEMENTS within a stored procedure. I access this stored procedure from ADO.NET. I want to use the XMLDataReader to loop through the XML document and produce an XML String which I then pass to another stored procedure somewhere else. I m using SQL Server 2000 so can't pass XML data types.

Regards,

shax at 2007-10-2 >

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech