25
Hello, I need some help to solve the following problem (if it is possible, that's it):
I'm using a xpath expression to programatically get data from my xml file. I want to transform ONLY the resulting nodes using xslt. In my example below I only want the Academic category to be transformed.
Is this possible? (please vb.net or c#). Many thanks.
My xml file:
<categories>
<category>
<categorynumber >1</categorynumber>
<categoryname>A cademic</categoryname>
<dateadded>04/10/2007</dateadded>
</category>
<category>
<categorynumber >2</categorynumber>
<categoryname>M anagement and professional jobs</categoryname>
<dateadded>05/10/2007</dateadded>
</category>
<category>
<categorynumber >3</categorynumber>
<categoryname>R esearch</categoryname>
<dateadded>06/10/2007</dateadded>
</category>
</categories>
My xslt file:
<xsl:template match="category ">
<html>
<body>
<H2>Job categories</H2>
<table>
<tr>
<td>Number</td>
<td>Name</td>
<td>Date</td>
</tr>
<tr>
<td><xsl:valu e-of select="categor ynumber"/></td>
<td><xsl:valu e-of select="categor yname"/></td>
<td><xsl:valu e-of select="dateadd ed"/></td>
</tr>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
My vb.net code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArg s) Handles Me.Load
Dim doc As XmlDocument = New XmlDocument()
doc.Load("c:\AS PNetProjects\Jo bEmailAlert\XML Categories.xml" )
Dim navigator As XPathNavigator = doc.CreateNavig ator
Dim xslt As XslTransform = New XslTransform()
xslt.Load("c:\A SPNetProjects\J obEmailAlert\XS LT_TestCategori es.xsl")
Dim path As String = ("//category[categoryname = 'Academic']")
Dim nodeList As XmlNodeList = doc.SelectNodes (path)
Dim Vacancy As XmlNode
For Each Vacancy In nodeList
Dim output As StringWriter
output = New StringWriter()
xslt.Transform( navigator, Nothing, output)
lblOutput.Text = output.ToString ()
output.Close()
Next
End Sub
