howto: use 'non sqlxml' xml returned by sql in dataset/reader or s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

it won't go into an xmlreader as the source is not a true sqlxml one

[the stored proc is returning a bunch of xml snippets inside a <root>]

all i want to do is get an xml string that i can pass back

any ideas?
 
Hi,

Then return it from SP as an output parameter of TEXT datatype
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ReadXml() on typed dataset causes InvalidCastException 1
ADO.NET Dataset to XML and displaying namespace 1
Filling a DataSet from a sql query against a XML schema 1
Error with SqlSmlCommand 7
LINQ to XML: stored procedure returning result of FOR XML PATH 4
XML, DataSet, DataGrid 3
null value in xml translates to empty string in dataset after ReadXML 1
Accessing SQL server through SQLXML... 2

Back
Top