XSL Transform Problem using Xml.XSL.Transfo rm

[John Lehmann]

I have an interesting problem. I am performing an XSL
transform using the System.Xml.Xsl. Transform class.
I have a database that contains the XSL style sheet
string. And it seems to work pretty well for simple
transforms. But as soon as I add Xsl variables or For each
loops to the XSL string in the db, it fails to transform
the XML. I can see that it will transform everything until
that point. ALso If I copy the XSL & XML I am trying to
transform from my watch window into a file.. It works
perfectly. Any Ideas?
The following is the C# code I am using to transform & the
XSL I am using to transform.

//Code
XmlDocument transform = new XmlDocument();
transform.LoadX ml(DataFormat); //DataFormat xsl string

XmlUrlResolver resolver = new XmlUrlResolver( );
XslTransform xslTran = new XslTransform();
xslTran.Load(tr ansform,resolve r,null);

XmlReader reader =
xslTran.Transfo rm(XmlData,null ,resolver);
reader.MoveToCo ntent();
string readerOutput = reader.ReadOute rXml();

//XSL
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:template match="DataSour ce">
<B>Report</B><BR/>
<TABLE CELLPADDING="1" CELLSPACING="1" Border="1">
<TR><TH>Agreeme nt Number</TH>
<TH>Name</TH>
<TH>Period</TH>
<TH>Due Date</TH>
<TH>Type</TH>
</TR>
<xsl:for-each select="tblRepo rt[code='XYZ']">
<TR>
<TD><xsl:valu e-of select="Agreeme ntNumber"/></TD>
<TD><xsl:valu e-of select="Name"/></TD>
<TD><xsl:valu e-of select="Period"/></TD>
<TD><xsl:valu e-of select="DueDate "/></TD>
<TD><xsl:valu e-of select="Type"/></TD>
</TR>
</xsl:for-each>
<</xsl:template>
</xsl:stylesheet>

[Oleg Tkachenko]

John Lehmann wrote:

I have an interesting problem. I am performing an XSL
transform using the System.Xml.Xsl. Transform class.
I have a database that contains the XSL style sheet
string. And it seems to work pretty well for simple
transforms. But as soon as I add Xsl variables or For each
loops to the XSL string in the db, it fails to transform
the XML. I can see that it will transform everything until
that point. ALso If I copy the XSL & XML I am trying to
transform from my watch window into a file.. It works
perfectly. Any Ideas?

That's bizarre. Most likely input XML is different that you think it is
so xsl:for-each just selects nothing. You didn't show us what XmlData is.
Also it's too expensive to build XmlDocument only to feed XslTransform -
you can rewrite transformation logic in more effective way:

XmlUrlResolver resolver = new XmlUrlResolver( );
XslTransform xslTran = new XslTransform();
XmlReader r = new XmlTextReader(n ew StringReader(Da taFormat));
xslTran.Load(r, resolver,null);

StringWriter sw = new StringWriter();
xslTran.Transfo rm(XmlData,null ,sw,resolver);
string output = sw.ToString();

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Oleg Tkachenko]

John Lehmann wrote:

The Xml Looks something like this:
<?xml version="1.0" encoding="UTF-8"?>
<DataSource>
<tblReport>
<AgreementNumbe r>1234567</AgreementNumber >
<Name>Martha Stuart</Name>
<Period>July 2000</Period>
<DueDate>Augu st 15, 2000</DueDate>
<Type>Type II</Type>
</tblReport>
</DataSource>
Well, considering that XML xsl:for-each in your stylesheet really selects nothing:
<xsl:for-each select="tblRepo rt[code='XYZ']">

because in your XML tblReport has no child Code element.
--
Oleg Tkachenko
http://www.tkachenko.c om/blog
Multiconn Technologies, Israel

[John Lehmann]

Just changing the way to open the transform WORK! Thanx
for you input!

John

-----Original Message-----
John Lehmann wrote:

I have an interesting problem. I am performing an XSL
transform using the System.Xml.Xsl. Transform class.
I have a database that contains the XSL style sheet
string. And it seems to work pretty well for simple
transforms. But as soon as I add Xsl variables or For each loops to the XSL string in the db, it fails to transform the XML. I can see that it will transform everything until that point. ALso If I copy the XSL & XML I am trying to
transform from my watch window into a file.. It works
perfectly. Any Ideas?That's bizarre. Most likely input XML is different that

you think it isso xsl:for-each just selects nothing. You didn't show us what XmlData is.Also it's too expensive to build XmlDocument only to feed XslTransform - you can rewrite transformation logic in more effective way:
XmlUrlResolv er resolver = new XmlUrlResolver( );
XslTransform xslTran = new XslTransform();
XmlReader r = new XmlTextReader(n ew StringReader (DataFormat));xslTran.Load(r ,resolver,null) ;

StringWriter sw = new StringWriter();
xslTran.Transf orm(XmlData,nul l,sw,resolver);
string output = sw.ToString();

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

.

[john lehmann]

Just changing the way to open the transform worked.
Unfortunately since I work on sensitive data at MS, I
could not copy everything as I see it exactly (I had to
cut out a lot of things). I may have missed my select..
But like I said.. it works now.

-----Original Message-----
John Lehmann wrote:

The Xml Looks something like this:
<?xml version="1.0" encoding="UTF-8"?>
<DataSource>
<tblReport>
<AgreementNumbe r>1234567</AgreementNumber >
<Name>Martha Stuart</Name>
<Period>July 2000</Period>
<DueDate>Augu st 15, 2000</DueDate>
<Type>Type II</Type>
</tblReport>
</DataSource>
Well, considering that XML xsl:for-each in your

stylesheet really selects nothing:

<xsl:for-each select="tblRepo rt[code='XYZ']">

because in your XML tblReport has no child Code element.
--
Oleg Tkachenko
http://www.tkachenko.c om/blog
Multiconn Technologies, Israel

.