This document already has a 'DocumentElement' node -Exception

Ehab Elfaham

Hello
I get this Exception when in try to convert data relation from Data set tables to xml to make an XmlDataSource supply it to Dynamic Menu Control.

This is the Code behind

DataSet ds = new DataSet();

            SqlCommand cmdmenu = new SqlCommand("select CategoryID,CategoryName from Category ", ConManager.Con());

            SqlCommand com2 = new SqlCommand("select CategoryIDToSub,subcategoryid ,SubCategoryName from CategorySub", ConManager.Con());
            SqlCommand cmd3 = new SqlCommand("select subcategoryid 'SubCategoryID2',Sub2CategoryName from CategorySub2", ConManager.Con());

            SqlDataAdapter menadapter = new SqlDataAdapter(cmdmenu.CommandText, ConManager.Con());
            SqlDataAdapter menadapter2 = new SqlDataAdapter(com2.CommandText, ConManager.Con());
            SqlDataAdapter menadapter3 = new SqlDataAdapter(cmd3.CommandText, ConManager.Con());
            menadapter.Fill(ds, "Menu");

            menadapter.SelectCommand = com2;
            menadapter2.Fill(ds, "SubMenu");
            menadapter3.SelectCommand = cmd3;
            menadapter3.Fill(ds, "SubSubMenu");

            DataColumn colParent =
            ds.Tables["Menu"].Columns["CategoryID"];
            DataColumn colChild =
            ds.Tables["SubMenu"].Columns["CategoryIDToSub"];

            DataRelation relation = new DataRelation("relationName",
            colParent,
            colChild, true);
            DataRelation Relation2 = new DataRelation("relationName2",
            ds.Tables["SubMenu"].Columns["subcategoryid"],
            ds.Tables["SubSubMenu"].Columns["SubCategoryID2"], true);

            relation.Nested = true;
            Relation2.Nested = true;

            ds.Relations.Add(relation);
            ds.Relations.Add(Relation2);

            XmlDataSource.Data = ds.GetXml();

            if (Request.Params["Sel"] != null)
                Page.Controls.Add(new System.Web.UI.LiteralControl("You selected " + Request.Params["Sel"]));

and this is the Xslt File Code

        ?Sel=

and this is the Menu Control and the XmlDataSource Code

                  TransformFile="~/TransformXSLT.xsl" XPath="MenuItems/MenuItem">

and the Xml Output dosn't contain more than one Root , This is the Xml output

      1
      Menu Item1

         1
         1
         Sub Menu Item1

            1
            Sub Sub Item1




      2
      Menu Item2


      3
      Menu Item3


      4
      Menu Item4


      5
      Menu Item5

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ehab Elfaham15y ago
Hello friend help me last night to solve it The problem is: if you don't supply dataset a name by default it's name property will be NewDataSet and this is where your XSL is not able to find Menus root node hence below result: replace :DataSet ds = new DataSet(); To:DataSet ds = new DataSet("Menus"); and now it's work but the problem now it's dos'nt show the subs levels only the items is display
Sam Hobbs15y ago
Please put all relevant information in the body of the question. In other words, don't put critical information in the subject without also putting it in the question.

Since no one has been able to help yet, I think you need to determine where the error message is coming from. I assume this is an ASP application and I am not experienced with debugging them. Perhaps it will help you to become more familiar with debugging ASP pages. I hope Suthish can help with that but I know there are many useful articles in this web site.
Ehab Elfaham15y ago
The exception is the title of the Question --Server Error in '/' Application. This document already has a 'DocumentElement' node. --and ther is no code line throw this exception ann line run will but when the page visible in the browser it's throw this execption in the page
Sam Hobbs15y ago
What exception? I looked at the entire thread and I don't see the exception.

Also, can you tell us what line of code that the exception occurs at?
Ehab Elfaham15y ago
Hello :) The Menu is three level and the Bold part is the level three off this menu and i need it . -any way i marked it any the same Exception this exist , this part not the problem
Suthish Nair15y ago

Am not sure...

Can you remove these xml nodes (marked in bold) and try..


         1
         1
         Sub Menu Item1

            1
            Sub Sub Item1