SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ICDBConnectionString"].ConnectionString);
        conn.Open();

        string SQL = "Select TUReportData from TUReport WHERE ConsumerID = @ConsumerID";

        SqlCommand cmd = new SqlCommand(SQL, conn);
        cmd.Parameters.Add(new SqlParameter("@ConsumerID", txtIDNumber.Text));

        SqlDataAdapter adapter = new SqlDataAdapter(cmd);

        DataTable dt = new DataTable();
        adapter.Fill(dt);

        dt.TableName = "XMLData";
        dt.ToString();
        dt.WriteXml("C:/inetpub/wwwroot/TUWebServiceCaller/Log/temp.xml");

        // Getting file path    
        string strXSLTFile = Server.MapPath("styles/style.xslt");
        string strXMLFile = Server.MapPath("Log/temp.xml");

        // Creating XSLCompiled object    
        XslCompiledTransform objXSLTransform = new XslCompiledTransform();
        objXSLTransform.Load(strXSLTFile);

        // Creating StringBuilder object to hold html data and creates TextWriter object to hold data from XslCompiled.Transform method    
        StringBuilder htmlOutput = new StringBuilder();
        TextWriter htmlWriter = new StringWriter(htmlOutput);

        // Creating XmlReader object to read XML content    
        XmlReader reader = XmlReader.Create(strXMLFile);

        // Call Transform() method to create html string and write in TextWriter object.    
        objXSLTransform.Transform(reader, null, htmlWriter);
        Results.InnerHtml  = htmlOutput.ToString();

        // Closing xmlreader object    
        reader.Close();

运行时没有错误，但 XSLT 似乎没有对 XML 进行样式设置，因为它以与传入的格式相同的格式返回。整个 xml 应该重新格式化，我自己的整个页面版本与节点一起显示我已经指定到位了

XSLT 这就是 XSLT 示例

<xsl:for-each select="AddressNA08">
    <tr>
        <td>
            <xsl:value-of select="ConsumerNo"/>
        </td>
        <td>
            <xsl:value-of select="InformationDate"/>
        </td>
        <td>
            <xsl:value-of select="Line1"/>
        </td>
        <td>
            <xsl:value-of select="Line2"/>
        </td>
        <td>
            <xsl:value-of select="Suburb"/>
        </td>
        <td>
            <xsl:value-of select="City"/>
        </td>
        <td>
            <xsl:value-of select="PostalCode"/>
        </td>
        <td>
            <xsl:value-of select="ProvinceCode"/>
        </td>
        <td>
            <xsl:value-of select="Province"/>
        </td>
        <td>
            <xsl:value-of select="AddressPeriod"/>
        </td>
        <td>
            <xsl:value-of select="OwnerTenant"/>
        </td>
        <td>
            <xsl:value-of select="AddressChanged"/>
        </td>
    </tr>
</xsl:for-each>

XML

<AddressNA08>
    <ConsumerNo>645511310</ConsumerNo>
    <InformationDate>20090227</InformationDate>
    <Line1>8 HAAKBOS ST</Line1>
    <Line2 />
    <Suburb>ONVERWACHT</Suburb>
    <City>ELLISRAS</City>
    <PostalCode>0557</PostalCode>
    <ProvinceCode>
        NP
    </ProvinceCode>
    <Province>LIMPOPO</Province>
    <AddressPeriod>
        06
    </AddressPeriod>
    <OwnerTenant>O</OwnerTenant>
    <AddressChanged>N</AddressChanged>
</AddressNA08>

这些都是我正在使用的文件

最佳答案

使用这样的方法，我通过 xslt 将 xml 转换为 xhtml:

   public static XmlDocument TransformToHtml(XmlDocument XmlDoc, XmlDocument XSLT) {

        var bArr = new System.Text.UTF8Encoding().GetBytes(XmlDoc.InnerXml);
        MemoryStream m = new MemoryStream(bArr);
        System.Xml.XPath.XPathDocument xDoc;
        XmlReaderSettings xrs = new XmlReaderSettings();
        xrs.CheckCharacters = false;
        using (XmlReader xr = XmlReader.Create(m, xrs)) {
            xDoc = new System.Xml.XPath.XPathDocument(xr);
        }

        StringBuilder resultString = new StringBuilder();
        var ws = new XmlWriterSettings();
        ws.CheckCharacters = false;
        ws.Indent = true;
        ws.OmitXmlDeclaration = true;
        XmlWriter writer = XmlWriter.Create(resultString, ws);
        var sets = new XsltSettings(true, true);

        string transformedXHTML = null;
        XslCompiledTransform transform = new XslCompiledTransform(false);
        transform.Load(XSLT, sets, null);
        transform.Transform(xDoc, writer);
        transformedXHTML = resultString.ToString();
        var doc = new XmlDocument();
        doc.LoadXml(transformedXHTML);
        return doc;
    }

你这样调用它(注意，缩短你的 xslt!):

        var xml = new XmlDocument();
        xml.LoadXml("<AddressNA08><ConsumerNo>645511310</ConsumerNo><InformationDate>20090227</InformationDate><Line1>8 HAAKBOS ST</Line1><Line2 />"
                   + "<Suburb>ONVERWACHT</Suburb><City>ELLISRAS</City><PostalCode>0557</PostalCode><ProvinceCode>NP</ProvinceCode><Province>LIMPOPO</Province>"
                   + "<AddressPeriod>06</AddressPeriod><OwnerTenant>O</OwnerTenant><AddressChanged>N</AddressChanged></AddressNA08>");

        var xslt = new XmlDocument();
        xslt.LoadXml("<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' xmlns='http://www.w3.org/1999/xhtml' version='1.0'>" +
                     "<xsl:output encoding='UTF-8' indent='yes' method='xml' standalone='no' omit-xml-declaration='no'/><xsl:template match='/'><xsl:for-each select='AddressNA08'>" +
                     "<tr><td><xsl:value-of select='ConsumerNo'/></td><td><xsl:value-of select='InformationDate'/></td><td><xsl:value-of select='Line1'/></td>" +
                     "<td><xsl:value-of select='Line2'/></td><td><xsl:value-of select='Suburb'/></td></tr></xsl:for-each></xsl:template></xsl:stylesheet>");
        var reslt = TransformToHtml(xml, xslt);

关于c# - 样式化 xml 返回相同的 xml 文档，一种让代码工作的方法，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/34197366/