Lee Kelleher

Archive for posts tagged with 'Microsoft Data Access Application Blocks'

  1. Convert XmlReader to String

    Posted on

    I was in the middle of developing a member look-up AJAX function for an Umbraco project, when I ran into a slight problem, (confusion rather), about how to pull the XML back from SQL Server and return it to the browser (AJAX). The SQL statement was straight-forward, very simple, does a LIKE query against the members table, no problem there. Added “FOR XML AUTO” to return the result-set back as an XML data-type ... all…

    Tags: , , , , , , ,