Transform Dataset using XSL in-place?

[Geoffrey Gallaway]

Hello,

I'm trying to apply an XSL to a dataset contents. More specifically, I
want to apply an XSL to a dataset or an XmlDataDocument and put the
resulting transformed data back into another DataSet or simply to
modify the current DataSet. The first part is easy:

Dim xmlDataDoc as XmlDataDocument = new XmlDataDocument(oracleDS)

Dim xslTrans as XslTransform = new XslTransform
xslTrans.Load("stylesheet.xsl")
xslTrans.Transform(xmlDataDoc, Nothing.. Stream)

Dim resultDS as new DataSet()
resultDS.ReadXml(?)

The problem becomes that XslTransform.Transform wants to output to a
stream and I would rather output to a DataSet. (Yes, I know that
transforming one DataSet to another DataSet is wrong, slow and
ineffecient). Is there a way to avoid the stream in the middle..

Thanks,
Geoffeg

[Oleg Tkachenko [MVP]]

Geoffrey Gallaway wrote:

Dim xmlDataDoc as XmlDataDocument = new XmlDataDocument(oracleDS)

Dim xslTrans as XslTransform = new XslTransform
xslTrans.Load("stylesheet.xsl")
xslTrans.Transform(xmlDataDoc, Nothing.. Stream)

Dim resultDS as new DataSet()
resultDS.ReadXml(?)

The problem becomes that XslTransform.Transform wants to output to a
stream and I would rather output to a DataSet. (Yes, I know that
transforming one DataSet to another DataSet is wrong, slow and
ineffecient). Is there a way to avoid the stream in the middle..

Sure. Transform to XmlReader and then load new DataSet from it.

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com