I have an XML document that is transformed using XSL that is stored in
a database. It works fine when the XSL is in a file, however when it
comes from the database, I only see the text in the XSL (like to column
headings) without any formatting.
Here is the relevant code:
SQLconn.Open();
SqlCommand SQLcmdc = new SqlCommand("SELECT xsl FROM xsl", SQLconn);
SqlDataReader dRsltc = SQLcmdc.ExecuteReader();
dRsltc.Read();
string sXml = dRsltc["xsl"].ToString();
SQLconn.Close();
StringReader sr = new StringReader(sXml);
xPathDoc = new XPathDocument(sr);
xslt.Load(xPathDoc,null,null);
xslt.Transform(xPathDoc, null, Response.OutputStream, null);
Any ideas?
Thanks,
Joseph Haas