XmlTextReader to a xml string

[Buddy Ackerman]

I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader
method? The trouble I'm having now is streaming the results to a string for
output as an XML document. Also, since the XML that comes from teh query is
not a complete document it's a fragment without a root element. So, any
ideas about how to get his into a string?

--Buddy

[Oleg Tkachenko [MVP]]

Buddy Ackerman wrote:

I want to use FOR XML in my query so I'm going to use the ExecuteXmlReader
method? The trouble I'm having now is streaming the results to a string for
output as an XML document. Also, since the XML that comes from teh query is
not a complete document it's a fragment without a root element. So, any
ideas about how to get his into a string?

What about something like

StringBuilder sb = new StringBuilder();
while (reader.Read())
sb.Append(reader.ReadOuterXml());
string xml = sb.ToString();

(didn't tested, but should work).
--
Oleg Tkachenko [XML MVP, XmlInsider]
http://blog.tkachenko.com