Styling xml data (in dataset) with XSLT
Hi,
I'm not sure where to post this, so I'll do it here.
Im am trying to style XML data with a style sheet. The problem however is that I currently export XML data from SQL Server with XML explicit into a dataset. I then use use DataTable and DataRow to run through all the elements in the dataset and use XmlWriter to write easch node to an XML file on the server. I then combine the two files with xslTransform.
This all works nicely, but seems to have a certain amount of overhead by first writing the XML to a file. Is it possible to style the XML data in the dataset directly through the use of a stylesheet or perhaps something else.
Your help would naturally be greatly appreciated.