Hi there

I have a drop down list reading from an XML Doc into a dataset and an XMLDataDOc, it is pulling in a list of unqique values from the XML doc and loading them to a drop down list, my prolem is that they are not sorted. I want to sort them alplabetically but im not sure who to do this, I read a suggestion yesterday to use an XSL file, but I am not sure how to incorporate this into my code below, any suggestions..
        if (!Page.IsPostBack)
        // load t
        {
            DataSet ds = new DataSet();
            ds.ReadXml(Server.MapPath("Banks.xml"));
            XmlDataDocument XMLDoc = new XmlDataDocument(ds);
            foreach (XmlNode XMLNodes in XMLDoc.SelectNodes("//bank[not(.=preceding::bank)]"))
            {

                ddl_Banks.Items.Add(new ListItem(XMLNodes.ChildNodes[0].InnerText.ToString()));

            }
        }

__________________
Thank You

I'd recommend creating a SortedList, adding the XML contents to that, and using that as the data source for the drop down list.

Plus, you don't need to do InnerText.ToString(), InnerText is already a string.

/- Sam Judson : Wrox Technical Editor -/

hi

thanks for the Tostring() tip, i changed it and it works fine cheers.
Would you have an example of how i can assign my XML to a sorted list, ive been looking at sorted lists and i know how to add elements throught code using the Add() method, but how can I add my XML file above and then create the Dropdownlist from it?

SortedList list = new SortedList();

foreach (XmlNode node in XMLDoc.SelectNodes("//bank[not(.=preceding::bank)]"))
{
   list.Add(node.InnerText);
}

ddl_Banks.DataSource = list;
ddl_Banks.DataBind();


/- Sam Judson : Wrox Technical Editor -/

thank you this work brilliant.