BackgroundColor is specified in this form as a parameter, and at the beginning of the XSLT, , A value of blue is set for BackgroundColor so that the background color is bgcolor=blue, and the effect of changing each row of the output data to blue is achieved.
Of course, in the example above, we set the XSLT parameters in a hard-coded way, which should normally be set in the ASP.net page. In asp.net 2.0, you can use the XsltArgumentList class to pass parameters to XSLT by using the following methods:
<%@ Page language= "C #"%>
<%@ Import namespace= "System.Data.SqlClient"%>
<%@ Import namespace= "System.Xml"%>
<%@ Import namespace= "SYSTEM.XML.XSL"%>
<%@ Import namespace= "System.Xml.XPath"%>
<%@ Import namespace= "System.Web.Configuration"%>
<script runat= "Server" >
void Page_Load (object sender, System.EventArgs e)
{
String connstring = Webconfigurationmanager.connectionstrings
["AdventureWorks"]. ConnectionString;
using (SqlConnection connection = new SqlConnection (connstring))
{
Connection. Open ();
SqlCommand command = new SqlCommand
("SELECT * from Production.productsubcategory as Categories" +
"FOR XML auto,elements", connection);
XmlReader reader = command. ExecuteXmlReader ();
XPathDocument Xpathdoc = new XPathDocument (reader);
String xslpath = Server.MapPath ("app_data/category.xsl");
XslCompiledTransform transform = new XslCompiledTransform ();
Transform. Load (Xslpath);
XsltArgumentList argslist = new XsltArgumentList ();
String backgroundcolor = "Tan";
ADD the required parameters to the XsltArgumentList object
Argslist.addparam ("BackgroundColor", "" ", backgroundcolor);
Transform. Transform (Xpathdoc, Argslist, response.output);
}
}
In which, note the bold bold section, first instantiate the XsltArgumentList class, then set the backgroundcolor color, and then use the XsltArgumentList class AddParam method, Set the BackgroundColor pass parameters to the XSLT Central Plains first. Finally, in the transform method of XslCompiledTransform, the second parameter, passing in the argslist just instantiated, enables you to pass the parameters to the XSLT dynamically in the ASPX page, as shown in the following illustration
In addition, in. NET 2.0, you can also call methods in an external class directly in XSLT. The outer class, which is called by the XSLT, is called an extension object. Here's an example of a class Datetimeconverter first, in which we have a way to format the specified date as follows:
Using System;
public class Datetimeconverter
{
Public Datetimeconverter ()
{}
public string Todatetimeformat (string data, string format)
{
DateTime date = datetime.parse (data);
Return date. ToString (format);
}
}
Place this class under the App_Code folder for easy invocation. To invoke this class in XSLT, first specify the extension object to invoke in the beginning of the XSLT file, as shown in the following code:
<?xml version= "1.0"? > >
<xsl:stylesheet version= "1.0"
Xmlns:xsl= "Http://www.w3.org/1999/XSL/Transform"
Xmlns:datetimeconverter= "Urn:datetimeconverter" >
<xsl:output method= "html"/>
<xsl:param name= "BackgroundColor" select= "Blue"/>
<xsl:template match= "/" >
<HTML>
<HEAD>
<TITLE> invoking extension objects from a XSLT Style Sheet </TITLE>
</HEAD>
<BODY>
<table border= "1" cellspacing= "1" cellpadding= "1" >
<center>
<xsl:for-each select= "//categories"
!--each record on a seperate row-->
<xsl:element name= "TR" >
<xsl:attribute name= "bgcolor"
<xsl:value-of select= "$BackGroundColor"/>
</xsl:attribute>
<xsl:element name= "TD"
<xsl:value-of select= "Productsubcategoryid"/>
</xsl:element>
<xsl:element name= "TD"
<xsl:value-of select= "Name"/>
</xsl:element>
<xsl:element name= "TD"
<xsl:attribute name= "Align" >center </xsl:attribute>
<xsl:value-of select= "Datetimeconverter:todatetimeformat
(ModifiedDate, ' F ') "/>
</xsl:element>
</xsl:element>
</xsl:for-each>
</center>
</table>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>
In the code above, we use the <xmlns:datetimeconverter= "Urn:datetimeconverter" to name the extended object to be called Datetimeconverter to facilitate the invocation below. and in order to format the date, through the <xsl:value-of select= "Datetimeconverter:todatetimeformat (modifieddate, ' F ')"/> Way, Call the method of the Todatetimeformat in the outer class datetimeconverter, note that this is represented as a class name: Method name (parameter table).
Next, in the ASPX page, the code to invoke the XSLT is as follows
<%@ Page language= "C #"%>
<%@ Import namespace= "System.Data.SqlClient"%>
<%@ Import namespace= "System.Xml"%>
<%@ Import namespace= "SYSTEM.XML.XSL"%>
<%@ Import namespace= "System.Xml.XPath"%>
<%@ Import namespace= "System.Web.Configuration"%>
<script runat= "Server" >
void Page_Load (object sender, System.EventArgs e)
{
String connstring = Webconfigurationmanager.connectionstrings
["AdventureWorks"]. ConnectionString;
using (SqlConnection connection = new SqlConnection (connstring))
{
Connection. Open ();
SqlCommand command = new SqlCommand ("SELECT * from Production.productsubcategory as Categories" +
"FOR XML auto,elements", connection);
XmlReader reader = command. ExecuteXmlReader ();
XPathDocument Xpathdoc = new XPathDocument (reader);
String xslpath = Server.MapPath ("app_data/category.xsl");
XslCompiledTransform transform = new XslCompiledTransform ();
Transform. Load (Xslpath);
XsltArgumentList argslist = new XsltArgumentList ();
String backgroundcolor = "Tan";
Argslist.addparam ("BackgroundColor", "" ", backgroundcolor);
Datetimeconverter converter = new Datetimeconverter ();
Argslist.addextensionobject ("Urn:datetimeconverter", converter);
Transform. Transform (Xpathdoc, Argslist, response.output);
}
}
</script>
In the above code, note that the Datetimeconverter class is instantiated first, and then the extended object is incremented by the XsltArgumentList AddExtensionObject method, which uses the "Urn:d Atetimeconverter, which indicates the alias of its extended object. The effect of running the following figure
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
