http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FXML%2FXslTransform
ASP.NET Tutorial/XML/XslTransform - История изменений
2026-04-29T19:34:59Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/XML/XslTransform&diff=2957&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://nfex.ru/index.php?title=ASP.NET_Tutorial/XML/XslTransform&diff=2958&oldid=prev
Admin: 1 версия
2010-05-26T11:57:34Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Display data from database in asp:Xml with xml transformation==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="XmlDataSet" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Untitled Page</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<br />
<div class="Box"><br />
<asp:Button ID="cmdDataSetToXml" runat="server" Text="Display DataSet as XML" OnClick="cmdDataSetToXml_Click" Width="185px"/><br />
<asp:Xml ID="XmlControl" runat="server" EnableViewState="False"></asp:Xml><br /><br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Default.aspx.cs<br />
using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
using System.Web.Configuration;<br />
using System.Xml;<br />
public partial class XmlDataSet : System.Web.UI.Page<br />
{<br />
protected void cmdDataSetToXml_Click(object sender, EventArgs e)<br />
{<br />
string connectionString =<br />
WebConfigurationManager.ConnectionStrings["Pubs"].ConnectionString;<br />
string SQL = "SELECT * FROM authors WHERE city="Oakland"";<br />
SqlConnection con = new SqlConnection(connectionString);<br />
SqlCommand cmd = new SqlCommand(SQL, con);<br />
SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
DataSet ds = new DataSet("AuthorsDataSet");<br />
con.Open();<br />
adapter.Fill(ds, "AuthorsTable");<br />
con.Close();<br />
XmlDataDocument dataDoc = new XmlDataDocument(ds);<br />
XmlControl.XPathNavigator = dataDoc.CreateNavigator();<br />
XmlControl.TransformSource = "Data.xsl";<br />
}<br />
}<br />
<br />
File: Data.xsl<br />
<?xml version="1.0" encoding="UTF-8" ?><br />
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
version="1.0"><br />
<xsl:template match="AuthorsDataSet"><br />
<h1>The Author List</h1><br />
<xsl:apply-templates select="AuthorsTable"/><br />
<i>Created through XML and XSLT</i><br />
</xsl:template><br />
<xsl:template match="AuthorsTable"><br />
<b>Name: </b><xsl:value-of select="au_lname"/>, <xsl:value-of select="au_fname"/><br />
<br/><br />
<b>Phone: </b> <xsl:value-of select="phone"/><br />
</xsl:template><br />
</xsl:stylesheet><br />
<br />
File: Web.config<br />
<?xml version="1.0"?><br />
<configuration><br />
<connectionStrings><br />
<add name="Pubs" connectionString="Data Source=localhost\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=Pubs;"/><br />
</connectionStrings><br />
</configuration></source><br />
<br />
<br />
<br />
== Read the transformed result of XslTransform and output the result (VB.net)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="VB" %><br />
<%@ Import Namespace="System.Xml" %><br />
<%@ Import Namespace="System.Xml.XPath" %><br />
<%@ Import Namespace="System.Xml.Xsl" %><br />
<script runat="server"><br />
sub Page_Load(Sender as Object, e as EventArgs)<br />
Dim objReader as New XmlTextReader(Server.MapPath("Data.xml"))<br />
<br />
Dim objDoc as XPathDocument = new XPathDocument(objReader)<br />
<br />
Dim objXSLT As XslTransform = New XslTransform()<br />
dim objWriter as XmlTextWriter = new XmlTextWriter(Server.MapPath("output.html"), nothing)<br />
try<br />
objXSLT.Load(Server.MapPath("Data.xsl"))<br />
dim objReader2 as XmlReader = objXslT.Transform(objDoc, nothing)<br />
While objReader2.Read()<br />
Response.Write("<b>" & objReader2.Name & "</b> " & _<br />
objReader2.Value & "<br>")<br />
End While<br />
catch ex As Exception <br />
Response.Write(ex.Message)<br />
finally<br />
objReader.Close<br />
objWriter.Close<br />
end try<br />
end sub <br />
</script><br />
<html><body><br />
</body></html><br />
<br />
File: Data.xml<br />
<br />
<?xml version="1.0"?><br />
<bookstore><br />
<book genre="asdf"><br />
<title>asdf</title><br />
<author><br />
<first-name>asdf</first-name><br />
<last-name>asdf</last-name><br />
</author><br />
<price>asdf</price><br />
</book><br />
<book genre="asdf"><br />
<title>asdf</title><br />
<author><br />
<first-name>asdf</first-name><br />
<last-name>asdf</last-name><br />
</author><br />
<price>asdf</price><br />
</book><br />
<book genre="asdf"><br />
<title>asdf</title><br />
<author><br />
<first-name>asdf</first-name><br />
<last-name>asdf</last-name><br />
</author><br />
<price>asdf</price><br />
</book><br />
</bookstore><br />
File: Data.xsl<br />
<?xml version="1.0"?><br />
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
xmlns:op="x-schema:books.xdr"<br />
version="1.0" ><br />
<xsl:template match="op:bookstore"><br />
<HTML><BODY><br />
<TABLE width="450"><br />
<TR><br />
<TD><b>Title</b></TD><br />
<TD><b>Price</b></TD><br />
</TR><br />
<xsl:apply-templates select="op:book"/><br />
</TABLE><br />
</BODY></HTML><br />
</xsl:template><br />
<xsl:template match="op:book"><br />
<TR><br />
<TD><xsl:value-of select="op:title"/></TD><br />
<TD><xsl:value-of select="op:price"/></TD><br />
</TR><br />
</xsl:template><br />
</xsl:stylesheet></source><br />
<br />
<br />
<br />
== Transform XML document to HTML==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="XmlToHtml" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Untitled Page</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Default.aspx.cs<br />
using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Xml.Xsl;<br />
using System.Xml.XPath;<br />
using System.Xml;<br />
public partial class XmlToHtml : System.Web.UI.Page<br />
{<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
string xslFile = Server.MapPath("Data.xslt");<br />
string xmlFile = Server.MapPath("Data.xml");<br />
string htmlFile = Server.MapPath("Data.htm");<br />
XslTransform transf = new XslTransform();<br />
transf.Load(xslFile);<br />
transf.Transform(xmlFile, htmlFile);<br />
XPathDocument xdoc = new XPathDocument(new XmlTextReader(xmlFile));<br />
XPathNavigator xnav = xdoc.CreateNavigator();<br />
XmlReader reader = transf.Transform(xnav, null);<br />
reader.MoveToContent();<br />
Response.Write(reader.ReadOuterXml());<br />
reader.Close();<br />
}<br />
}<br />
File: Data.xml<br />
<?xml version="1.0"?><br />
<Data><br />
<DVD ID="1" Category="Category 1"><br />
<Title>title 1</Title><br />
<Director>directory 2</Director><br />
<Price>1</Price><br />
<Starring><br />
<Star>star 1</Star><br />
<Star>star 2</Star><br />
</Starring><br />
</DVD><br />
<DVD ID="2" Category="Category 2"><br />
<Title>title 2</Title><br />
<Director>directory 2</Director><br />
<Price>2</Price><br />
<Starring><br />
<Star>star 3</Star><br />
<Star>star 4</Star><br />
</Starring><br />
</DVD><br />
</Data><br />
<br />
File: Data.xsl<br />
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"><br />
<xsl:output method="xml"/><br />
<xsl:template match="/"><br />
<xsl:element name="Movies"><br />
<xsl:apply-templates select="//DVD" /><br />
</xsl:element><br />
</xsl:template><br />
<xsl:template match="DVD"><br />
<xsl:element name="{name()}"><br />
<xsl:attribute name="ID"><br />
<xsl:value-of select="@ID"/><br />
</xsl:attribute><br />
<xsl:attribute name="Title"><br />
<xsl:value-of select="Title/text()"/><br />
</xsl:attribute><br />
<xsl:apply-templates select="Starring" /><br />
</xsl:element><br />
</xsl:template><br />
<xsl:template match="Starring"><br />
<xsl:element name="Stars"><br />
<xsl:attribute name="Name"><br />
<xsl:value-of select="Star/text()"/><br />
</xsl:attribute><br />
</xsl:element><br />
</xsl:template><br />
<br />
</xsl:stylesheet></source><br />
<br />
<br />
<br />
== Use XslTransform to trasnform XML data to HTML file (VB.net)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="VB" %><br />
<%@ Import Namespace="System.Xml" %><br />
<%@ Import Namespace="System.Xml.XPath" %><br />
<%@ Import Namespace="System.Xml.Xsl" %><br />
<script runat="server"><br />
sub Page_Load(Sender as Object, e as EventArgs)<br />
Dim objReader as New XmlTextReader(Server.MapPath("Data.xml"))<br />
<br />
Dim objDoc as XPathDocument = new XPathDocument(objReader)<br />
Dim objNav as XPathNavigator = objDoc.CreateNavigator()<br />
<br />
Dim objXSLT As XslTransform = New XslTransform()<br />
dim objWriter as XmlTextWriter = new XmlTextWriter(Server.MapPath("output.html"), nothing)<br />
try<br />
objXSLT.Load(Server.MapPath("Data.xslt"))<br />
objXSLT.Transform(objDoc, nothing, objWriter)<br />
Response.Write("File written successfully")<br />
catch ex As Exception <br />
Response.Write(ex.Message)<br />
finally<br />
objReader.Close<br />
objWriter.Close<br />
end try<br />
end sub <br />
</script><br />
<html><body><br />
</body></html><br />
<br />
File: Data.xml<br />
<br />
<?xml version="1.0"?><br />
<bookstore><br />
<book genre="asdf"><br />
<title>asdf</title><br />
<author><br />
<first-name>asdf</first-name><br />
<last-name>asdf</last-name><br />
</author><br />
<price>asdf</price><br />
</book><br />
<book genre="asdf"><br />
<title>asdf</title><br />
<author><br />
<first-name>asdf</first-name><br />
<last-name>asdf</last-name><br />
</author><br />
<price>asdf</price><br />
</book><br />
<book genre="asdf"><br />
<title>asdf</title><br />
<author><br />
<first-name>asdf</first-name><br />
<last-name>asdf</last-name><br />
</author><br />
<price>asdf</price><br />
</book><br />
</bookstore><br />
File: Data.xsl<br />
<?xml version="1.0"?><br />
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
xmlns:op="x-schema:books.xdr"<br />
version="1.0" ><br />
<xsl:template match="op:bookstore"><br />
<HTML><BODY><br />
<TABLE width="450"><br />
<TR><br />
<TD><b>Title</b></TD><br />
<TD><b>Price</b></TD><br />
</TR><br />
<xsl:apply-templates select="op:book"/><br />
</TABLE><br />
</BODY></HTML><br />
</xsl:template><br />
<xsl:template match="op:book"><br />
<TR><br />
<TD><xsl:value-of select="op:title"/></TD><br />
<TD><xsl:value-of select="op:price"/></TD><br />
</TR><br />
</xsl:template><br />
</xsl:stylesheet></source></div>
Admin