XslPath help

aowen355 · July 13th, 2005, 07:43 AM

I have a program that pulls data from a SQL server and converts it to XML. The next thing i want to do is figure out a way to apply XSL to this XML doc. Ideally I would like to just append a line to the top of the XML doc like this <?xml-stylesheet type="text/xsl" href="Sample.xsl"?> From what I understand, XslPath is supposed to do this, but it is causing errors in the final outputted XML document.

Any suggestions?

-Andrew

jacob · July 13th, 2005, 08:46 AM

How do you apply the stylesheet line? I do not know the XslPath property or method? How about this...

Code:

public static void AddXslIncludeInstruction(string filename, string stylesheet)
{
    XmlDocument doc = null;
    try
    {
        doc = new XmlDocument();
        doc.Load(filename);
        if(stylesheet != null)
        {
            doc.InsertBefore(doc.CreateProcessingInstruction(
                "xml-stylesheet", "type=\"text/xsl\" href=\"" + stylesheet + "\""),
                doc.DocumentElement);
        }
        doc.Save(filename);
    }
    catch(Exception e)
    {
        System.Console.WriteLine(e.Message);
        throw;
    }
}

(the above code is not tested, but I think it works)

Hope it helps, Jacob.

jacob · July 13th, 2005, 08:49 AM

Just tested it... It works! Jacob.

aowen355 · July 14th, 2005, 01:01 PM

Thank you sir, I appreciate your help!

-Andrew