How to sort XML file... using XSL ???

Question

Hi i want to sort XML file. How to do it ? How XSL can be used to sort XML file? Here is my XML...... 1234567890 02/04/2005 17:21 xxxxxxx abcdefghij 04/04/2005 09:12 yyyyyyy ooopppsssaaa 01/04/2005 12:46 zzzzzzzz Can you provide me XSL file to sort it.... Also guide me how XSL can be created & apply on XML & Why it is applied ? Please guide me. thank you bhavin gajjar

marcelvojta · Answer

Hi XSL file for transform XML to XML with sorting is below. .. I think the process of transformation using C# is clear .. using System; using System.IO; using System.Xml; using System.Xml.XPath; using System.Xml.Xsl; public class Sample { private const String filename = data.xml; private const String stylesheet = sort.xsl; public static void Main() { XslTransform xslt = new XslTransform(); xslt.Load(stylesheet); XPathDocument xpathdocument = new XPathDocument(filename); XmlTextWriter writer = new XmlTextWriter(Console.Out); writer.Formatting=Formatting.Indented; xslt.Transform(xpathdocument null writer null); System.Console.ReadLine(); } }

mibuyt · Answer

Hi I don't think there is much differences between windows app and web app for xslt transformation. Maybe you can elaborate in details... Cheers.

onlybhavin · Answer

Hi Thank you for the solution. I got it how to sort XML using XSL. It uses web. BUT... If i want such sort XML in winwdows application and not using web. Then what can I do? Please guide me. I need it b'coz i have one log file in XML which will be created on web but i have to view it in sorted order using windows application. Help me.... Byeeee bhavin

marcelvojta · Answer

Your file isn't well formed so I repaired it. (data.xml) 1234567890 02/04/2005 17:21 xxxxxxx abcdefghij 04/04/2005 09:12 yyyyyyy ooopppsssaaa 01/04/2005 12:46 zzzzzzzz and file sort.xsl Date Title Time Descritpion if you change date in for title data will be sorted using value of title :) Place both files into the same directory and open data.xml in IE to see result. Good tool for work with XM? files is Altova XMLspy www.altova.com Tutorial about XML/XSL is here http://www.w3schools.com/xml/default.asp By.