How to build xml with C# look like this

Question

0.00/5 (No votes)

See more:

And also the code view in Dataset Source, create xml file using c# and send the data to dataset

XML

<?xml version="1.0" encoding="utf-8" ?> 

<Company>

<Employees>

  <Employee Name="Mahesh Chand" Age="30" Phone="6101233333" /> 

  <Employee Name="Rose Garner" Age="56" Phone="2133428778" /> 

  <Employee Name="Amger Jap" Age="22" Phone="9092349800" /> 

  <Employee Name="Mike Gold" Age="35" Phone="9908088823" /> 

  <Employee Name="Renee Flower" Age="19" Phone="4848901003" /> 

</Employees>

</Company>

I have tried this code but its not working ( the xml not like the top one)

C#

XmlDocument doc = new XmlDocument();

//(1) the xml declaration is recommended, but not mandatory
XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
XmlElement root = doc.DocumentElement;
doc.InsertBefore(xmlDeclaration, root);

//(2) string.Empty makes cleaner code
XmlElement element1 = doc.CreateElement(string.Empty, "body", string.Empty);
doc.AppendChild(element1);

XmlElement element2 = doc.CreateElement(string.Empty, "level1", string.Empty);
element1.AppendChild(element2);

XmlElement element3 = doc.CreateElement(string.Empty, "level2", string.Empty);
XmlText text1 = doc.CreateTextNode("text = "+"");
element3.AppendChild(text1);
element2.AppendChild(element3);

XmlElement element4 = doc.CreateElement(string.Empty, "level2", string.Empty);
XmlText text2 = doc.CreateTextNode("other text");
element4.AppendChild(text2);
element2.AppendChild(element4);

doc.Save("ChartReport.xml");

DataSet ds = new DataSet();
ds.ReadXml("ChartReport.xml");
ds.WriteXmlSchema("DataSet1.xsd");

this.reportViewer1.RefreshReport();

Posted 20-Dec-14 23:42pm

elmutasim23

Updated 21-Dec-14 0:42am

George Jonsson

v6

Add a Solution

Comments

DamithSL 21-Dec-14 5:48am

you need to get xml from which data? update the question with your code

elmutasim23 21-Dec-14 5:57am

I want only to create xml using c# and then send the data to dataset

Kornfeld Eliyahu Peter 21-Dec-14 5:58am

http://mattgemmell.com/what-have-you-tried/

3 solutions

Solution 1

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A very quick search using part of your question as the search term gave over 2,000,000 hits: Google "Create xml file using c#"[^]
The second hit is MSDN guiding you through the process: MSDN: "Creating an XML File"[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.

Posted 21-Dec-14 0:06am

OriginalGriff

Comments

elmutasim23 21-Dec-14 6:10am

I tried but most of the xml using C# is not the same as the top that I post

Solution 3

It is not exactly clear what it is you actually want to do, because your code is faraway from the presented XML data.

If you want to create an XML file with the same structure as you have presented, you need to add several XmlAttribute[^] to your XmlElement.

In the code below I have created the first element. Adding more is just a matter of repetition.

C#

XmlDocument doc = new XmlDocument();

//(1) the xml declaration is recommended, but not mandatory
XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
XmlElement root = doc.DocumentElement;
doc.InsertBefore(xmlDeclaration, root);

XmlElement elementRoot = doc.CreateElement(string.Empty, "Company", string.Empty);
doc.AppendChild(elementRoot);

//(2) string.Empty makes cleaner code
XmlElement element1 = doc.CreateElement(string.Empty, "Employees", string.Empty);
elementRoot.AppendChild(element1);

XmlElement element2 = doc.CreateElement(string.Empty, "Employee", string.Empty);

// Create and add Name attribute
XmlAttribute attrib1 = doc.CreateAttribute("Name");
attrib1.Value = "Mahesh Chand";
element2.Attributes.Append(attrib1);

// Create and add Age attribute
XmlAttribute attrib2 = doc.CreateAttribute("Age");
attrib2.Value = "30";
element2.Attributes.Append(attrib2);

// Create and add Phone attribute
XmlAttribute attrib3 = doc.CreateAttribute("Phone");
attrib3.Value = "6101233333";
element2.Attributes.Append(attrib3);

element1.AppendChild(element2);

// Add more elements with attributes
// ...

doc.Save("ChartReport.xml");

That said and done, the question arise why you want to first create an XML file and then load it into the dataset.

Posted 21-Dec-14 1:21am

George Jonsson

Comments

elmutasim23 21-Dec-14 14:17pm

the xml is easy set and also the text can be changed in dataset but the datatable write much code and can't be changed easily

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2014-12-21T00:48:00

1) XML is just text, so you have the possibility to build it with StringBuilder[^] if you like

2) You can build XML as you tried, but of course, you need to adapt the code. Copy-pasting like a full won't help. See LinqPad[^] sample:

C#

private XmlNode NewEmployee(XmlDocument doc, string name, int age, string phone)
{
  var e = doc.CreateElement("Employee");
  var aA = doc.CreateAttribute("Age");
  aA.Value = age.ToString();
  
  var aN = doc.CreateAttribute("Name");
  aN.Value = name;
  
  var aP = doc.CreateAttribute("Phone");
  aP.Value = phone;
  
  e.Attributes.Append(aN);
  e.Attributes.Append(aA);
  e.Attributes.Append(aP);
  
  return e;
}

void Main()
{
	var doc = new XmlDocument();
	var root = doc.CreateElement("Company");
	doc.AppendChild(root);
	var es = doc.CreateElement("Employees");
	root.AppendChild(es);
	
	es.AppendChild(NewEmployee(doc, "Mahesh Chand", 30, "6101233333"));
	es.AppendChild(NewEmployee(doc, "Rose Garner",56, "2133428778"));
	
	doc.DumpFormatted();
}

3) And of couse you can use serialization, and strongly typed classes. See following example:

C#

[XmlRoot("Company")]
public class Company
{
	[XmlArrayItem("Employee", typeof(Employee))]
    [XmlArray("Employees")]
	public List<Employee> Employees;
}

public class Employee
{
 [XmlAttribute("Name")]
 public string Name {get; set;}
 [XmlAttribute("Age")]
 public int Age {get; set;}
 [XmlAttribute("Phone")]
 public string Phone {get;set;}
}

void Main()
{
	var c = new Company();
	c.Employees = new List<Employee>() 
		{
			new Employee() {Name = "Mahesh Chand", Age=30, Phone = "6101233333"},
			new Employee() {Name = "Rose Garner", Age=56, Phone="2133428778"}
		};
	
	
	XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
	ns.Add(string.Empty, string.Empty);
	TextWriter w = new StringWriter();
    var s = new XmlSerializer(typeof(Company));
    s.Serialize(w, c, ns);
    w.Flush();
	
	
	w.ToString().Dump();
}

How to build xml with C# look like this

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us