對DataSet應用XSLT轉換 Applying an XSLT Transform to a DataSet

.NET Framework Developer's Guide

The <b>WriteXml</b> method of the <b>DataSet</b> enables you to write the contents of a <b>DataSet</b> as XML data. A common task is to then transform that XML to another format using XSL Transformations (XSLT). However, synchronizing a <b>DataSet</b> with an <b>XmlDataDocument</b> enables you to apply an XSLT stylesheet to the contents of a <b>DataSet</b> without having to first write the contents of the <b>DataSet</b> as XML data using <b>WriteXml</b>.

The following example populates a <b>DataSet</b> with tables and relationships, synchronizes the <b>DataSet</b> with an <b>XmlDataDocument</b>, and writes a portion of the <b>DataSet</b> as an HTML file using an XSLT stylesheet. Following are the contents of the XSLT stylesheet.

&lt;xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"&gt;

&lt;xsl:template match="CustomerOrders"&gt;

  &lt;HTML&gt;

  &lt;STYLE&gt;

  BODY {font-family:verdana;font-size:9pt}

  TD   {font-size:8pt}

  &lt;/STYLE&gt;

    &lt;BODY&gt;

    &lt;TABLE BORDER="1"&gt;

      &lt;xsl:apply-templates select="Customers"/&gt;

    &lt;/TABLE&gt;

    &lt;/BODY&gt;

  &lt;/HTML&gt;

&lt;/xsl:template&gt;

&lt;xsl:template match="Customers"&gt;

    &lt;TR&gt;&lt;TD&gt;

      &lt;xsl:value-of select="ContactName"/&gt;, &lt;xsl:value-of select="Phone"/&gt;&lt;BR/&gt;

    &lt;/TD&gt;&lt;/TR&gt;

      &lt;xsl:apply-templates select="Orders"/&gt;

&lt;xsl:template match="Orders"&gt;

  &lt;TABLE BORDER="1"&gt;

    &lt;TR&gt;&lt;TD valign="top"&gt;&lt;B&gt;Order:&lt;/B&gt;&lt;/TD&gt;&lt;TD valign="top"&gt;&lt;xsl:value-of select="OrderID"/&gt;&lt;/TD&gt;&lt;/TR&gt;

    &lt;TR&gt;&lt;TD valign="top"&gt;&lt;B&gt;Date:&lt;/B&gt;&lt;/TD&gt;&lt;TD valign="top"&gt;&lt;xsl:value-of select="OrderDate"/&gt;&lt;/TD&gt;&lt;/TR&gt;

    &lt;TR&gt;&lt;TD valign="top"&gt;&lt;B&gt;Ship To:&lt;/B&gt;&lt;/TD&gt;

        &lt;TD valign="top"&gt;&lt;xsl:value-of select="ShipName"/&gt;&lt;BR/&gt;

        &lt;xsl:value-of select="ShipAddress"/&gt;&lt;BR/&gt;

        &lt;xsl:value-of select="ShipCity"/&gt;, &lt;xsl:value-of select="ShipRegion"/&gt;  &lt;xsl:value-of select="ShipPostalCode"/&gt;&lt;BR/&gt;

        &lt;xsl:value-of select="ShipCountry"/&gt;&lt;/TD&gt;&lt;/TR&gt;

  &lt;/TABLE&gt;

&lt;/xsl:stylesheet&gt;

The following code is the code to fill the <b>DataSet</b> and apply the XSLT style sheet.

[Visual Basic]

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Xml

Imports System.Xml.Xsl

Public Class Sample

  Public Shared Sub Main()

    Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Initial Catalog=northwind;Integrated Security=SSPI")

    nwindConn.Open()

    Dim myDataSet As DataSet = New DataSet("CustomerOrders")

    Dim custDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Customers", nwindConn)

    custDA.Fill(myDataSet, "Customers")

    Dim ordersDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Orders", nwindConn)

    ordersDA.Fill(myDataSet, "Orders")

    nwindConn.Close()

    myDataSet.Relations.Add("CustOrders", _

                            myDataSet.Tables("Customers").Columns("CustomerID"), _

                            myDataSet.Tables("Orders").Columns("CustomerID")).Nested = true

    Dim xmlDoc As XmlDataDocument = New XmlDataDocument(myDataSet) 

    Dim xslTran As XslTransform = New XslTransform

    xslTran.Load("transform.xsl")

    Dim writer As XmlTextWriter = New XmlTextWriter("xslt_output.html", System.Text.Encoding.UTF8)

    xslTran.Transform(xmlDoc, Nothing, writer)

    writer.Close()

  End Sub

End Class

[C#]

using System;

using System.Data;

using System.Data.SqlClient;

using System.Xml;

using System.Xml.Xsl;

public class Sample

{

  public static void Main()

  {

    SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Initial Catalog=northwind;Integrated Security=SSPI;");

    nwindConn.Open();

    DataSet custDS = new DataSet("CustomerDataSet");

    SqlDataAdapter custDA = new SqlDataAdapter("SELECT * FROM Customers", nwindConn);

    custDA.Fill(custDS, "Customers");

    SqlDataAdapter ordersDA = new SqlDataAdapter("SELECT * FROM Orders", nwindConn);

    ordersDA.Fill(custDS, "Orders");

    nwindConn.Close();

    custDS.Relations.Add("CustOrders",

                         custDS.Tables["Customers"].Columns["CustomerID"],

                         custDS.Tables["Orders"].Columns["CustomerID"]).Nested = true;

    XmlDataDocument xmlDoc = new XmlDataDocument(custDS); 

    XslTransform xslTran = new XslTransform();

    xslTran.Load("transform.xsl");

    XmlTextWriter writer = new XmlTextWriter("xslt_output.html", System.Text.Encoding.UTF8);

    xslTran.Transform(xmlDoc, null, writer);

    writer.Close();

  }

}

本文轉自斯克迪亞部落格園部落格，原文連結：http://www.cnblogs.com/sgsoft/archive/2004/08/25/36309.html，如需轉載請自行聯系原作者