XML / XSL

pmarfleet wrote:

Can I modify my stylesheet to indent the nodes?

public static string ExecuteQueryAndTransform(string connectionString, string queryText, string xslPath)
        {
            string result = String.Empty;

            SqlXmlCommand cmd = new SqlXmlCommand(connectionString);
            cmd.XslPath = xslPath;
            cmd.RootTag = "Root";
            cmd.CommandText = queryText;
            
            using (Stream strm = cmd.ExecuteStream())
            {
                using (StreamReader sr = new StreamReader(strm))
                {
                    result = sr.ReadToEnd();
                }
            }

            return result;

        }

public static string ExecuteQueryAndTransform(string connectionString, string queryText, string xslPath)
        {
            string result = String.Empty;
            SqlXmlCommand cmd = new SqlXmlCommand(connectionString);
            
            if (!queryText.EndsWith("For XML Auto", StringComparison.CurrentCultureIgnoreCase))
            {
                queryText += " For XML Auto";
            }            
            cmd.RootTag = "Root";
            cmd.CommandText = queryText;
            
            using (Stream strm = cmd.ExecuteStream())
            {
                XmlTextReader reader = new XmlTextReader(strm);
                XPathDocument xd = new XPathDocument(reader, XmlSpace.Preserve);
                XslCompiledTransform xslt = new XslCompiledTransform();
                xslt.Load(xslPath);
                StringWriter stringWriter = new StringWriter();
                XmlTextWriter writer = new XmlTextWriter(stringWriter);
                writer.Formatting = Formatting.Indented;
                writer.Indentation = 3;
                writer.IndentChar = ' ';
                xslt.Transform(xd, null, writer);
                result = stringWriter.ToString();
            }
     }