Filter,sort xml before binding to repeater

How I can filter, sort xml before binding it to a repeater? I have a xml data which I need to filter on the basis of querystring and then sort it before binding it into repeater.

I know how to bind xml with repeater and its working fine too but I am facing problem in filtering based on query string and sorting.

Any help would really be appreciated?

You can use an XPath query to select only the elements you want from the XML document. I can give you a generic example, but if you provide an example of your XML and how you'd like to filter it, we can give you a more specific example. Also, what programming language are you using?

My xml is like this: I m using C#

Code:

---

<Categories>
  <Category>
    <Title>Food<Title>
    <Date>12/1/2009</Date>
    <Duration>12/1/2009-12/1/2011</Duration>
    <Description>Who is hungry</Description>
  </Category>
</Categories>

---

I want to sort on the basis of Date and duration and filter if querystring matches with title

Try something like this:

Code:

---

using System;
using System.Xml;
using System.Xml.Xsl;

// Use XSL to sort input file by date and duration           
XslCompiledTransform xsl = new XslCompiledTransform();
xsl.Load("sort_categories.xslt");

XmlDocument doc = new XmlDocument();
using (XmlWriter writer = XmlWriter.Create(doc.CreateNavigator().AppendChild()))
{
    xsl.Transform("categories.xml", writer);
}

// Use XPath to select item(s) whose title matches
// query string
string title = Request.QueryString["title"].ToString();
XmlNodeList nodes = doc.SelectNodes(
    String.Format("/Categories/Category[Title='{0}']", title));

---

The variable nodes will then contain the sorted, filtered XML. The stylesheet (sort_categories.xslt) looks like this:

Code:

---

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" indent="yes"/>
  <xsl:template match="/">

    <Categories>
      <xsl:for-each select="Categories/Category">
        <xsl:sort select="Date" />
        <xsl:sort select="Duration" />
        <Category>
          <Title>
            <xsl:value-of select="Title"/>
          </Title>
          <Date>
            <xsl:value-of select="Date"/>
          </Date>
          <Duration>
            <xsl:value-of select="Duration"/>
          </Duration>
          <Description>
            <xsl:value-of select="Description"/>
          </Description>
        </Category>
      </xsl:for-each>
    </Categories>

  </xsl:template>
</xsl:stylesheet>

---

If you want the dates to sort correctly, you'll probably need to use substrings to extract the year, month and day as shown here: http://www.xml.com/pub/a/2002/07/03/...rm.html?page=2