Xml File

Sweety

How to create an xml file in the form of c# list.The list will be populated with the data from database.

Can any1 help me on this

4 Replies

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

Sam Hobbs15y ago
What do you mean by list? Can you define it in terms of C# code?

What is the purpsoe of the list?

I ask these things just to help us understand what you need. We are eager to help you but we need to understand.
0
Vulpes15y ago
Assuming you've filled an "Employees" datatable with data from the database table, which is consistent with the Employee class, then you'll need to copy the rows to the list as follows:

List list = new List();
foreach(DataRow row in dt.Rows)
{
Employee e = new Employee((string)row["ID"], (string)row["ID"], (decimal)row["Salary"]);
list.Add(e);
}

and the code to serialize the list to disk will be the same as before.

Incidentally, you can write the datatable directly to an XML file, without going through a list at all, using the DataTable.WriteXml(fileName) method. It won't be quite the same as what we've done here but it should be good enough :)
0
Sweety15y ago
i need to bind database data to list...
0
Vulpes15y ago
The easiest way is to use XML serialization.

Here's a simple example:

using System;
using System.Collections.Generic;
using System.Xml.Serialization;
using System.IO;

public class Employee
{
public string ID {get; set;}
public string Name {get; set;}
public decimal Salary {get; set;}

public Employee(string id, string name, decimal salary)
{
ID = id;
Name = name;
Salary = salary;
}

public Employee() // need to have a parameterless constructor as well
{
}
}

class Program
{
static void Main()
{
List list = new List();
list.Add(new Employee("1", "sweety", 20000));
list.Add(new Employee("2", "vulpes", 10000));

XmlRootAttribute root = new XmlRootAttribute();
root.ElementName = "Employees";
root.IsNullable = false;

XmlSerializer xs = new XmlSerializer(typeof(List), root);

using (Stream s = File.Create("employees.xml"))
{
xs.Serialize(s, list);
}
}
}

This code should produce the following XML file:

1
sweety
20000

2
vulpes
10000

0