How to convert parent child list to xml

ravi kiran

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..

11 Replies

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

ravi kiran14y ago
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 kiran14y ago
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 kiran14y ago
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...
Vulpes14y ago
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:

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 kiran14y ago
Hi,
after converting to xml,i want to create dynamic menu by using that xml...
ravi kiran14y ago
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 kiran14y ago
Hi,
i am sending my code through attachment plz once check it....
ravi kiran14y ago
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.
Vulpes14y ago
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 kiran14y ago
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.
Vulpes14y ago
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