0
Reply

Styling xml data (in dataset) with XSLT

ruang

ruang

Apr 26 2005 12:05 PM
1.7k
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.