How to convert parent child list to xml

Question

Hi, By using entity framework i converted from query to list,the list has some childrens now i need to convert that list to xml.pso please send me code its an urgent requirement to me..

ravi kiran · Answer

Hi, thanks my problem solved i created dynamic menu by using entity framework but now the problem is i want to add style sheet to that dynamic menu....please tell me..

ravi kiran · Answer

Hi, here i am sending one more attachment i.e print screen of table which i created in database and that table i used in my code....plz help me...

ravi kiran · Answer

Hi, Actuall my requirement is to create a dynamic menu by using entity framework,i did upto some extent getting error when i am trying to convert from list to xml ,i am sending my code through attachment plz once check it and send me code its very urgent requirement....thanks alot for ur response...

Vulpes · Answer

Well, you'll need to decorate your Nav class with some attributes to get the serializer to generate the XML file as you want it. I don't have time to reproduce all 18 Navigation nodes manually but I've used the first 6 to show that it's feasible to do this using XML serialization: using System; using System.Collections.Generic; using System.Xml.Serialization; using System.IO; [XmlType("Navigation")] public class Nav { public int NavigationId { get; set; } public string NavigationName { get; set; } public string ParentNavigationId { get; set; } public int NavigationOrder { get; set; } public string Url { get; set; } [XmlElement("Navigation")] public List Children { get; set; } [XmlIgnore] public bool Parent { get; set; } } class Test { static void Main() { var list = new List (); var nav = new Nav(); nav.NavigationId = 1; nav.NavigationName = "Home"; nav.NavigationOrder = 1; nav.Url = "//home.aspx"; list.Add(nav); var nav2 = new Nav(); nav2.NavigationId = 2; nav2.NavigationName = "Contacts"; nav2.NavigationOrder = 1; nav2.Url = ""; var list2 = new List (); var nav3 = new Nav(); nav3.NavigationId = 3; nav3.NavigationName = "Create Contact"; nav3.ParentNavigationId = "2"; nav3.NavigationOrder = 1; nav3.Url = "//Contacts/CreateContact.aspx"; list2.Add(nav3); var nav4 = new Nav(); nav4.NavigationId = 4; nav4.NavigationName = "View Contacts"; nav4.ParentNavigationId = "2"; nav4.NavigationOrder = 2; nav4.Url = "//Contacts/ViewContacts.aspx"; list2.Add(nav4); var nav5 = new Nav(); nav5.NavigationId = 5; nav5.NavigationName = "Contact Report"; nav5.ParentNavigationId = "2"; nav5.NavigationOrder = 3; nav5.Url = "//Contacts/ContactReport.aspx"; list2.Add(nav5); var nav6 = new Nav(); nav6.NavigationId = 6; nav6.NavigationName = "Import Contacts"; nav6.ParentNavigationId = "2"; nav6.NavigationOrder = 4; nav6.Url = "//Contacts/ImportContacts.aspx"; list2.Add(nav6); nav2.Children = list2; list.Add(nav2); /* need the following code to get serializer to display Menus rather than ArrayOfNavigation as the root node */ XmlAttributes attribs = new XmlAttributes(); attribs.XmlRoot = new XmlRootAttribute("Menus"); XmlAttributeOverrides attribOverrides = new XmlAttributeOverrides(); attribOverrides.Add(typeof(List ), attribs); var xs = new XmlSerializer(typeof(List ), attribOverrides); // serialize to disk using (Stream s = File.Create("Menus.xml")) { xs.Serialize(s, list); } // deserialize to a new list List listResult; using(Stream s = File.OpenRead("Menus.xml")) { listResult = (List )xs.Deserialize(s); } } } The resulting XML file looks like this: /2001/XMLSchema-instance"> 1 Home 1 //home.aspx 2 Contacts 1 3 Create Contact 2 1 //Contacts/CreateContact.aspx 4 View Contacts 2 2 //Contacts/ViewContacts.aspx 5 Contact Report 2 3 //Contacts/ContactReport.aspx 6 Import Contacts 2 4 //Contacts/ImportContacts.aspx

ravi kiran · Answer

Hi, after converting to xml,i want to create dynamic menu by using that xml...

ravi kiran · Answer

Hi , here i am sending one more attachment i.e print screen of table which i used in my code...geeting errors when i am trying to convert from list to xml,please help me its an urgent requirement to me...

ravi kiran · Answer

Hi, i am sending my code through attachment plz once check it....

ravi kiran · Answer

List Nav > x = sss.ConvertfromNavigaiontoNav(dd.ToList()); here in x variable i am getting list which have childrens also now i need to convert it into xml.

Vulpes · Answer

If it's a List you have, then I suggest you try the following code and see whether what you get resembles what you want: var xs = new XmlSerializer(typeof(List )); // serialize to disk using (Stream s = File.Create("Menus.xml")) { xs.Serialize(s, list); } // deserialize to a new list List list2; using(Stream s = File.OpenRead("Menus.xml")) { list2 = (List )xs.Deserialize(s); }

ravi kiran · Answer

Hi, required ouput shold be given below 1 Home 1 //home.aspx 2 Contacts 1 3 Create Contact 2 1 //Contacts/CreateContact.aspx 4 View Contacts 2 2 //Contacts/ViewContacts.aspx 5 Contact Report 2 3 //Contacts/ContactReport.aspx 6 Import Contacts 2 4 //Contacts/ImportContacts.aspx 7 Opportunity 1 8 Create Opportunity 7 1 //Opportunity/CreateOpportunity.aspx 9 View Opportunity 7 2 //Opportunity/ViewOpportunity.aspx 10 View Opportunity Reports 7 3 //Opportunity/ViewOpportunityReports.aspx 11 Documents 1 12 Create Document 11 1 //Documents/CreateDocument.aspx 13 View Documents 11 2 //Documents/ViewDocuments.aspx 14 Accounts 1 15 Create Account 14 1 //Accounts/CreateAccount.aspx 16 View Accounts 14 2 //Accounts/ViewAccount.aspx 17 Import Accounts 14 3 //Accounts/ImportAccounts.aspx 18 View Account Reports 14 4 //Accounts/ViewAccountReports.aspx In list it is showing Home have 0 children, Contact have 4 children,opportunity have 3 children,Documents have 2 children and Accounts have 4 children.plz send me code its an urgent requirement to me.

Vulpes · Answer

You'll probably be able to use XML serialization to convert a List to and from an XML file. Note however that your class 'T' needs to have an implicit or explicit parameterless constructor for this to work. Here's a simple example: using System; using System.Collections.Generic; using System.Xml.Serialization; using System.IO; public class Person { public string Name {get; set;} } class Test { static void Main() { var list = new List (); var c = new Person(); c.Name = "ravi"; list.Add(c); var c2 = new Person(); c2.Name = "Vulpes"; list.Add(c2); var xs = new XmlSerializer(typeof(List )); // serialize to disk using (Stream s = File.Create("Persons.xml")) { xs.Serialize(s, list); } // deserialize to a new list List list2; using(Stream s = File.OpenRead("Persons.xml")) { list2 = (List )xs.Deserialize(s); } // check it worked foreach(Person cust in list2) Console.WriteLine(cust.Name); Console.ReadKey(); } } The resulting XML file, persons.xml, looks like this: Ravi Vulpes