XML / XSL

//   excuse the C#
string   tmpFilePath = Path.GetTempFileName();

try
{
   TextReader rdr = new StreamReader(Assembly.GetExecutingAssembly().GetManifestResourceStream("MyDataAccess.MySchemaFile.xsd");
   TextWriter wr = new StreamWriter(tmpFilePath, false);

   wr.WriteLine(rdr.ReadToEnd());

   wr.Close();
   rdr.Close();

   //   now tmpFilePath can be used in your SqlXmlCommand.SchemaPath until done, e.g.,
   //   cmd.SchemaPath = tmpFilePath;
}
catch (Exception e)
{
   //   handle the exception
}
finally
{
   //  get rid of that temp file!
   if (File.Exists(tmpFilePath))   File.Delete(tmpFilePath);
}

<br />
string transfrormerStyleSheet = LoadTransfrormer();<br />
XmlDocument transformationDocument = new XmlDocument();<br />
transformationDocument.LoadXml(transfrormerStyleSheet);<br />
XmlNodeReader transformationReader = new XmlNodeReader(transformationDocument);<br />
XmlDocument guiXmlDocument = new XmlDocument();				<br />
xmlDocument.LoadXml(xmlAsString);	<br />
<br />
XslTransform transformer = new XslTransform(); <br />
transformer.Load(transformationReader);<br />
<br />
XPathNavigator xpn = xmlDocument.CreateNavigator();<br />
FileStream fs = new FileStream(Environment.CurrentDirectory+"\\TempXMLstream.xml",FileMode.Create);<br />
StreamWriter sw = new StreamWriter(fs,System.Text.Encoding.UTF8);<br />
transformer.Transform(xpn,null,sw);<br />
sw.Flush();<br />
sw.Close();<br />
fs.Close();<br />