none
CDATA in response RRS feed

  • Question

  • <usp_Load_DetailResponse xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo">
    <StoredProcedureResultSet0>
    <StoredProcedureResultSet0 xmlns="http://schemas.microsoft.com/Sql/2008/05/ProceduresResultSets/dbo/usp_Load_Detail">
    <UnNamedColumn0>
    <![CDATA[<A1><B1>0</B1></A1>]]>
    </UnNamedColumn0>
    </StoredProcedureResultSet0>
    </StoredProcedureResultSet0>
    <ReturnValue>0</ReturnValue>
    </usp_Load_DetailResponse>

    How do I eliminate the CDATA and get the desired nodes(<A1><B1>0</B1></A1>) as xml. 

    I modified the XSD and replaced the UnNamedColumn0 with <A1><B1>0</B1></A1> and the SP uses XML XPath to create the output.



    • Edited by Sax001 Monday, October 8, 2018 7:39 PM
    • Moved by Stanly Fan Tuesday, October 9, 2018 1:50 AM From Winform
    Monday, October 8, 2018 7:39 PM

Answers

All replies