http://www.wiley.com/extras
Look for ADO.NET and XML: ASP.NET on the Edge
Download the sample code for the last three chapters. There is an example in
there on how to do an XSLT transform directly to the HTTP stream using XML
from SQL Server.
A couple of notes:
1. By default, SQL Server does not add a <root> element if you do not
specify the root. Make sure you have a <root> or you will not have valid XML
2. The code samples are 1.0, so may need a tweak or two. The methodology is
basically sound. I add this caveat as Microsoft broke some of the XML
functionality moving to 1.1
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
************************************************
Think Outside the Box!
************************************************
"K Bryan" <Ke***********@campi.org> wrote in message
news:uF**************@TK2MSFTNGP10.phx.gbl...
Hi there,
I'm a little stuck and would appreciate ANY help getting over this hurdle.
Let's say that I've got a SQL Server stored procedure that includes FOR
XML AUTO, ELEMENTS
And that within a .Net Web Form, I'd like to call that stored procedure
and then apply an .XSLT file to it.
What would the code look like to do that?
Any help would be GREATLY appreciated.
Thanks,
_K