How do I return XML from a Stored Procedure?

by

First, SqlCommand has a ExecuteXmlReader method, not ExecuteXMlReader as you wrote (this is misspelling). Second, SqlCommand.ExecuteXmlReader method returns a value of type XmlReader, not a DataReader as is in your example. So changing your code to:

using (XmlReader reader = cmd.ExecuteXmlReader())
{
    while(reader.Read())
    {
        string s = reader.ReadOuterXml();
        // do something with s
    }
}

should solve the issue.

More Related Contents:

  1. Generate C# class from XML
  2. Capture Stored Procedure print output in .NET
  3. How to serialize/deserialize to `Dictionary` from custom XML not using XElement?
  4. Serializing private member data
  5. How would you compare two XML Documents?
  6. Format a date in XML via XSLT
  7. How to deal with XML in C#
  8. Serialize Property as Xml Attribute in Element
  9. .net XML Serialization – Storing Reference instead of Object Copy
  10. What is the difference between Linq to XML Descendants and Elements
  11. Calling Oracle stored procedure from C#?
  12. How to decode string to XML string in C#
  13. How to store data locally in .NET (C#) [closed]
  14. get line number for XElement here
  15. Entity Framework with XML Files [closed]
  16. Read a XML (from a string) and get some fields – Problems reading XML
  17. XML Parsing – Read a Simple XML File and Retrieve Values
  18. Error Deserializing Xml to Object – xmlns=” was not expected
  19. XmlTextReader vs. XDocument
  20. How to pass XML from C# to a stored procedure in SQL Server 2008?
  21. Deserializing XML File with multiple element attributes – attributes are not deserializing
  22. Removing nodes from an XmlDocument
  23. Generating XML file using XSD file
  24. How to check for valid xml in string input before calling .LoadXml()
  25. Data at the root level is invalid [duplicate]
  26. How to get xpath from an XmlNode instance
  27. XmlSerializer Performance Issue when Specifying XmlRootAttribute
  28. Finding element in XDocument?
  29. How can I remove empty xmlns attribute from node created by XElement
  30. How can I convert a DataTable to an XML file in C#?

Leave a Comment