We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

Problem with xml and Xslt data transfer...help.[Answered] RSS

1 reply

Last post Apr 15, 2015 06:13 AM by Zhi Lv - MSFT

‹ Previous Thread|Next Thread ›

Shortcuts

slimbunny

Participant

858 Points

1472 Posts

Problem with xml and Xslt data transfer...help.

Apr 14, 2015 06:44 PM|slimbunny|LINK

I am trying to retrieve data from XML into XSLT and I am only able to get the record ID value all other nodes appears as static text.... Please review the codes below and share with me what I could possibly be doing wrong. Thanks

Xml CODE

XmlDocument doc = new XmlDocument();
XmlNode oNode = null;

XmlDeclaration oDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
doc.AppendChild(oDeclaration);
                
XmlElement root = doc.CreateElement("IDRoot", "XNamespace.Xmlns=http://www.w3.org/2001/XMLSchema-instance" + " xsi:noNamespaceSchemaLocation=" + "http://localhost:3465/TestSchema.xsd");
doc.AppendChild(root);
 
//Creating First Element(Version)
XmlElement IDNode = doc.CreateElement("PID", "XNamespace.Xmlns=http://www.w3.org/2001/XMLSchema-instance" + " xsi:noNamespaceSchemaLocation=" + "http://localhost:3465/TestSchema.xsd");
oNode = doc.CreateElement("PID");
oNode.InnerText= PID.ToString(CultureInfo.InvariantCulture);
IDNode .AppendChild(oNode);
               
 
XmlElement ProjectNode = doc.CreateElement("ProjectName", "XNamespace.Xmlns=http://www.w3.org/2001/XMLSchema-instance" + " xsi:noNamespaceSchemaLocation=" + "http://localhost:3465/TestSchema.xsd");
oNode = doc.CreateElement("ProjectName");
oNode.InnerText= _projectName.ToString(CultureInfo.InvariantCulture);
ProjectNode.AppendChild(oNode);

doc.Save(@"C:\prpject\myxml.xml");

XslTransform --- works but only PID data value is carried over to XSLT file

XslCompiledTransform xslt = new XslCompiledTransform();
 xslt.Load(xslfilename);
 
// Transform the file and output an HTML string. 
string HTMLoutput;
StringWriter writer = new StringWriter();
xslt.Transform(xmlFileName, null, writer);
HTMLoutput = writer.ToString();

XSLT output

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:user">
  <xsl:output method="html" encoding="utf-8"  indent="no"/>
  <xsl:template match="IDRoot">
  <xsl:text disable-output-escaping='yes'>&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&gt;</xsl:text>
   <html>
     <head>
       <title>
         <xsl:value-of select="Subject" />
       </title>
     </head>
      <body style="font-family:Arial;font-size:12pt;background-color:#EEEEEE">
        <h2>Comment </h2>
        <table width="width: 100%;" cellpadding="0" cellspacing="0" border="1">
          <tr valign="top" bgcolor="#9acd32">
            <th style="width:200px;"></th>
            <th style="width:85%;"></th>
          </tr>
         <xsl:for-each select="ITBRoot"> 
          <tr>
            <td width="200">
              <div style="font-size: 12pt">
                <b>Project ID:</b>
              </div>
            </td>
            <td>
              <xsl:value-of select="PID"/>  <---DOES show the data value
              <Output>
                <xsl:attribute name="PID"> <---DOES show the data value
                  <xsl:text> </xsl:text>
                  <xsl:value-of select="PID"/> <---DOES show the data value
                </xsl:attribute>
              </Output>
            </td>
          </tr>
          
            <tr>
              <td width="200">
                <div style="font-size: 12pt">
                  <b>Project Name:</b>
                </div>
              </td>
              <td>
                <xsl:value-of select="ProjectName"/>  <---does not show the data value
                <Output>
                  <xsl:attribute name="ProjectName">  <---does not show the data value
                    <xsl:text> </xsl:text>
                    <xsl:value-of select="ProjectName"/> <---does not show the data value
                  </xsl:attribute>
                </Output>
              </td>
            </tr>

  </xsl:template>
</xsl:stylesheet>

A Lifetime ASP.NET DEVELOPER

Zhi Lv - MSF...

All-Star

45489 Points

7008 Posts

Microsoft

Re: Problem with xml and Xslt data transfer...help.

Apr 15, 2015 06:13 AM|Zhi Lv - MSFT|LINK

Hi slimbunny,

slimbunny

//Creating First Element(Version)
XmlElement IDNode = doc.CreateElement("PID", "XNamespace.Xmlns=http://www.w3.org/2001/XMLSchema-instance" + " xsi:noNamespaceSchemaLocation=" + "http://localhost:3465/TestSchema.xsd");
oNode = doc.CreateElement("PID");
oNode.InnerText= PID.ToString(CultureInfo.InvariantCulture);
IDNode .AppendChild(oNode);
               
 
XmlElement ProjectNode = doc.CreateElement("ProjectName", "XNamespace.Xmlns=http://www.w3.org/2001/XMLSchema-instance" + " xsi:noNamespaceSchemaLocation=" + "http://localhost:3465/TestSchema.xsd");
oNode = doc.CreateElement("ProjectName");

oNode.InnerText= _projectName.ToString(CultureInfo.InvariantCulture);

ProjectNode.AppendChild(oNode);
doc.Save(@"C:\prpject\myxml.xml");

As for this issue, please check the above code, and modify it as below:

XmlElement ProjectNode = doc.CreateElement("ProjectName", "XNamespace.Xmlns=http://www.w3.org/2001/XMLSchema-instance" + " xsi:noNamespaceSchemaLocation=" + "http://localhost:3465/TestSchema.xsd");
oNode = doc.CreateElement("ProjectName");

oNode.InnerText= ProjectName.ToString(CultureInfo.InvariantCulture);

ProjectNode.AppendChild(oNode);
doc.Save(@"C:\prpject\myxml.xml");

Best Regards,
Dillion

.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.

‹ Previous Thread|Next Thread ›