{"id":110,"date":"2007-10-16T16:26:00","date_gmt":"2007-10-16T16:26:00","guid":{"rendered":"https:\/\/wdev-blog.azurewebsites.net\/index.php\/2007\/10\/16\/how-to-transform-a-dataset-using-xml-and-xslt-in-net-2-0\/"},"modified":"2007-10-16T16:26:00","modified_gmt":"2007-10-16T16:26:00","slug":"how-to-transform-a-dataset-using-xml-and-xslt-in-net-2-0","status":"publish","type":"post","link":"http:\/\/www.panahy.nl\/index.php\/2007\/10\/16\/how-to-transform-a-dataset-using-xml-and-xslt-in-net-2-0\/","title":{"rendered":"How to Transform A DataSet using Xml and Xslt in .Net 2.0"},"content":{"rendered":"
\n

<\/span>\/\/ Creating DOM Document
<\/span>XmlDocument doc = <\/span>new<\/span> XmlDocument();<\/span> <\/o:p><\/span><\/p>\n

<\/o:p><\/span>\/\/ Get hold of the XML string from the dataset
<\/span>doc.LoadXml(ds.GetXml());<\/o:p><\/span><\/p>\n

\/\/Load XSL and Tranform
<\/span>XslCompiledTransform myXslTrans = <\/span>new<\/span> XslCompiledTransform();
<\/span>string<\/span> path = Directory.GetCurrentDirectory();
<\/span>myXslTrans.Load(path + @”<\/span>PrintView.xslt<\/span>“);<\/o:p><\/span><\/p>\n

\/\/ Using a StringWriter for Streaming part
<\/span>StringWriter stringWriter = <\/span>new<\/span> StringWriter();<\/o:p><\/span><\/p>\n

\/\/ The actual transformation
<\/span>myXslTrans.Transform(doc.DocumentElement, <\/span>null<\/span>, stringWriter);
<\/span>stringWriter.Flush();<\/o:p><\/span><\/p>\n

\/\/ Consuming the transformed results
<\/span>webBrowser1.Document.Write(stringWriter.ToString());<\/o:p><\/span><\/p>\n

\/\/doc.Save(“Example.xml”);<\/o:p><\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\/\/ Creating DOM DocumentXmlDocument doc = new XmlDocument(); \/\/ Get hold of the XML string from the datasetdoc.LoadXml(ds.GetXml()); \/\/Load XSL and TranformXslCompiledTransform myXslTrans = new XslCompiledTransform();string path = Directory.GetCurrentDirectory();myXslTrans.Load(path + @”PrintView.xslt“); \/\/ Using a StringWriter for Streaming partStringWriter stringWriter = new StringWriter(); \/\/ The actual transformationmyXslTrans.Transform(doc.DocumentElement, null, stringWriter);stringWriter.Flush(); \/\/ Consuming the transformed resultswebBrowser1.Document.Write(stringWriter.ToString()); \/\/doc.Save(“Example.xml”);<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[85,29],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"post-thumbnail":false},"uagb_author_info":{"display_name":"Pouya Panahy","author_link":"http:\/\/www.panahy.nl\/index.php\/author\/pouya\/"},"uagb_comment_info":0,"uagb_excerpt":"\/\/ Creating DOM DocumentXmlDocument doc = new XmlDocument(); \/\/ Get hold of the XML string from the datasetdoc.LoadXml(ds.GetXml()); \/\/Load XSL and TranformXslCompiledTransform myXslTrans = new XslCompiledTransform();string path = Directory.GetCurrentDirectory();myXslTrans.Load(path + @”PrintView.xslt“); \/\/ Using a StringWriter for Streaming partStringWriter stringWriter = new StringWriter(); \/\/ The actual transformationmyXslTrans.Transform(doc.DocumentElement, null, stringWriter);stringWriter.Flush(); \/\/ Consuming the transformed resultswebBrowser1.Document.Write(stringWriter.ToString()); \/\/doc.Save(“Example.xml”);","_links":{"self":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/110"}],"collection":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/comments?post=110"}],"version-history":[{"count":0,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/110\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/media?parent=110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/categories?post=110"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.panahy.nl\/index.php\/wp-json\/wp\/v2\/tags?post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}