SQL joins with Venn Diagrams

Basic SQL Xml techniques

SQL tips

A Little something about SQL Null

Row Number function in SQL

3/12/2008 7:33:45 PM (GMT Standard Time, UTC+00:00)    Comments [0] 

GuidanceExplorer is a great reference 

11/26/2006 6:55:52 AM (GMT Standard Time, UTC+00:00)    Comments [0] 

System.Xml.XSL.XslTransform is deprecated(obsolete) in .Net 2.0  framework. What this means is the old method of applying  the transform method(XSL.Transform) is not going to work in the future versions of the framework. Instead, you need to apply the transform method of System.Xml.Xsl.XslCompiledTransform class.

I  literally spent hours trying to figure out how to do this. all the online samples were pretty "useless", until i found this. Thanks to everyone. It made me feel better, that i was not alone with this problem.

This is the helper class, Many thanks to Willis

public static class XslHelper
{
   public static String TransformInMemory(XslCompiledTransform transform, String input)
   {
      StringBuilder sb = new StringBuilder();
      XmlReader xReader = XmlReader.Create(new StringReader(input));
      XmlWriter xWriter = XmlWriter.Create(sb);
      transform.Transform(xReader, xWriter);
      return sb.ToString();
   }

   public static String TransformInMemory(String transform, String input)
   {
      XslCompiledTransform xsl = new XslCompiledTransform();
      xsl.Load(XmlReader.Create(new StringReader(transform)));
      return TransformInMemory(xsl, input);
   }
}

Happy Programming!!

11/13/2006 1:36:33 AM (GMT Standard Time, UTC+00:00)    Comments [0]