Solved

sort menu items from xml

Posted on 2011-09-19
4
297 Views
Last Modified: 2012-06-27
Hey guys i have an menu and populating it from a data base

here the code in c#:

 
protected void Page_Load(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        using (SqlConnection conn = new SqlConnection(connStr))
        {
            string sql = "Select id, title, parent_id, url from menu";
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            da.Fill(ds);
            da.Dispose();
        }

        ds.DataSetName = "Menus";
        ds.Tables[0].TableName = "menu";
        DataRelation relation = new DataRelation("ParentChild", ds.Tables["menu"].Columns["id"], ds.Tables["menu"].Columns["parent_id"], true);

        relation.Nested = true;
        ds.Relations.Add(relation);

        xmlDataSource.Data = ds.GetXml();
    }

Open in new window


my problem is, how do to do a sort on the sub menus?

0
Comment
Question by:JCWEBHOST
4 Comments
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 125 total points
Comment Utility
In the database store the sub menu items in the same order as you wish to sort either ascending or descending.

0
 
LVL 8

Assisted Solution

by:gena17
gena17 earned 125 total points
Comment Utility
If you do want to sort the sub-menus, but do not want to sort the root level items, I suggest to make a copy of the table withing the DataSet after you bring the data from the database. Then sort the second table and create a relation between the two tables.
0
 
LVL 3

Assisted Solution

by:ExpertLogin_890
ExpertLogin_890 earned 125 total points
Comment Utility
for softing the xml data go through with below links

http://www.example-code.com/vbdotnet/xmlSort.asp

other wise you can try below code


using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Xml;
using System.Xml.XPath;
using System.Text;

namespace CodeBank.System_Xml_XPath {
    /// <summary>
    /// Summary description for SortingXML.
    /// </summary>
    public partial class SortingXML : System.Web.UI.Page {
   
        protected void Page_Load(object sender, System.EventArgs e) {
            StringBuilder unsorted = new StringBuilder();
            StringBuilder sorted = new StringBuilder();
            string xpath = "/Customers/Customer/ContactName";

            //Create XPathDocument class so we can get a navigator
            XPathDocument doc = new XPathDocument(Server.MapPath("customers.xml"));
            XPathNavigator nav = doc.CreateNavigator();

            XPathNodeIterator nodeIter1 = nav.Select(xpath);
            while (nodeIter1.MoveNext()) {
                unsorted.Append(nodeIter1.Current.Value + "<br />");
            }
            this.lblUnsorted.Text = unsorted.ToString();

            //Compile xpath expression so we can add a sort to it
            XPathExpression exp = nav.Compile(xpath);
            exp.AddSort("text()",XmlSortOrder.Ascending,XmlCaseOrder.None,"",
                XmlDataType.Text);

            //select nodes so we can see the sort
            XPathNodeIterator nodeIter2 = nav.Select(exp);
            while (nodeIter2.MoveNext()) {
                sorted.Append(nodeIter2.Current.Value + "<br />");
            }        
            this.lblSorted.Text = sorted.ToString();
        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
       
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    

        }
        #endregion
    }
}
0
 
LVL 7

Assisted Solution

by:gopaltayde
gopaltayde earned 125 total points
Comment Utility
populate below two tables into dataset
1) "Select id, title, parent_id, url from menu where parent_id is null"
2) "Select id, title, parent_id, url from menu where parent_id is not null order by id" (or order by title)

Then set the relation between them.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now