XSLT / XML / C#|XS|SL|LT|TX|XM|ML|LC|C

XSLT / XML / C# (转）

这个例程展示了如何将xslt 应用于从数据库中读出的XML格式数据上. 例程完全使用C#语言编写:

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
using System.XML;
using System.XML.Xsl;

public class XsltTransform
    {
        public static void Transform()
        {
            SqlConnection nwindConn = new SqlConnection("Data
            Source=INMUMIS123;database=northwind;uid=sa;pwd=;");
            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");

            // This is for generating the output in new HTML
            XMLTextWriter writer = new XMLTextWriter("xslt_output.HTML",
            System.Text.Encoding.UTF8);
            writer.Close();

            // This is for writing in the current page
            xslTran.Transform(XMLDoc, null, Response.OutputStream);

        }
}

　

上面这个称为XsltTransform的类连接到一个数据库,将数据填充到XMLDocument 中,然后将下面提供的Xslt应用于这个XML.

<%@ Page language="c#"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="javascript (ECMAScript)">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>

    <script>
    public void Page_Load(object sender, System.EventArgs e)
    {
        Transform();
    }
    public void Transform()
    {
        SqlConnection nwindConn = new SqlConnection("Data
        Source=INMUMIS123;database=northwind;uid=sa;pwd=;");
        nwindConn.Open();