Using XSLT in SandBox Web Part

Question

I need to fetch data from the list (which I am getting in XML) and then I need to apply the XML data to my XSLT so that it can produce HTML output.

I tried using SPUtility.GetGenericSetupPath to get the XSLT which resides in 14 hive but SPUtility.GetGenericSetupPath doesn't supported in Sandbox web parts.

I got that I will be uploading my XSLT somewhere into SharePoint Library, but the real question is How will I consume it?

SPUtility.GetGenericSetupPath to get the XSLT isn't working in Sandbox.

How will I get the path of XSLT?

This is what I have done with Farm Web Part, now I'm converting it into Sandbox Web Part.

            //Transform XML To HTML using ContactList.XSLT
            XslCompiledTransform XMLTrnsfrm = new XslCompiledTransform();
            XMLTrnsfrm.Load(SPUtility.GetGenericSetupPath("TEMPLATE\\LAYOUTS\\ContactsXSLT.xslt"));

Any other solution in mind guys?

Answer 1

In a sandboxed solution you'll not be able to read from the file system so you need to put the XSLT file into a SharePoint document library then read it like this:

var file = web.GetFile(pathToXslt);
var bytes = file.OpenBinary();
var stream = new MemoryStream(bytes);
var reader = new XmlTextReader(stream);
var XMLTransfrm = new XslCompiledTransform();
XMLTransfrm.Load(reader);