How to create xml using c#

Question

0.00/5 (No votes)

See more:

hi,

i want to create XML like this

XML

<RECORD>
  <FIELD ID="1"MAX_LENGTH="100" />
  <FIELD ID="2" MAX_LENGTH="100" />
  <FIELD ID="3" MAX_LENGTH="7"/>
  <FIELD ID="4" MAX_LENGTH="100"/>
  <FIELD ID="5" MAX_LENGTH="100"/>
 </RECORD>
 <ROW>
  <COLUMN SOURCE="3" NAME="Col1" />
  <COLUMN SOURCE="2" NAME="Col2" />
  <COLUMN SOURCE="1" NAME="Col3" />
  <COLUMN SOURCE="4" NAME="Col4" />
 </ROW>

This is what i have done so far, but its throwing error in the last line as "This document already has a documentelement node"

C#

XmlDocument xmlDoc = new XmlDocument();
XmlElement rootNode = xmlDoc.CreateElement("RECORD");
xmlDoc.AppendChild(rootNode);

int dbIndex = 0;
foreach (ColumnMapping columnMapping in columnMappings)
{
  XmlNode userNode = xmlDoc.CreateElement("FIELD");
  XmlAttribute attribute = xmlDoc.CreateAttribute("ID");
  attribute.Value = dbIndex.ToString();
  userNode.Attributes.Append(attribute);
  rootNode.AppendChild(userNode);
  dbIndex++;
}

rootNode = null;
rootNode = xmlDoc.CreateElement("ROW");
xmlDoc.AppendChild(rootNode);

Posted 28-Oct-14 5:33am

Arjun Menon U.K

Updated 28-Oct-14 5:43am

v2

Add a Solution

Comments

PIEBALDconsult 28-Oct-14 12:02pm

What do you intend to do with it? Just hold it in memory? Store it somewhere?

3 solutions

Solution 2

XmlDocument won't allow that -- it can only support one document at a time. The example you show at the top is two documents. Either combine them into one document (with one root node), or produce them separately.

"
XML documents form a tree structure that starts at "the root" and branches to "the leaves".

XML documents must contain a root element. This element is "the parent" of all other elements.

The elements in an XML document form a document tree. The tree starts at the root and branches to the lowest level of the tree.
"
-- http://www.w3schools.com/xml/xml_tree.asp[^]

Posted 28-Oct-14 5:55am

PIEBALDconsult

Updated 28-Oct-14 6:17am

v4

Comments

Arjun Menon U.K 28-Oct-14 11:57am

shall i create two docs and combine them and assign to another? Can you provide a sample

PIEBALDconsult 28-Oct-14 12:01pm

You would still have to provide one root node for the combined document.

CPallini 28-Oct-14 12:20pm

5.

Arjun Menon U.K 28-Oct-14 12:54pm

Hi thanks for the elaborate detailing.
So if i want to create an XML like this dynamically.. How can i do this?

PIEBALDconsult 28-Oct-14 13:01pm

You can do it in a string as far as I'm concerned, but you can't do it with a class that expects to contain an XML document and will verify the well-formedness of what you put in it.
What are you going to do with it? If you just want to write it to a file, you can use an XmlWriter as Dilan says, but you still won't be able to read it into an XmlDocument or XDocument.
Your best bet is to create one document and make those two documents parts of it:
<TABLE><RECORD...><ROW...></TABLE>

Arjun Menon U.K 28-Oct-14 13:01pm

I can say those two docs belong to a root node called TABLE, so how can i combine the two XmlDocs with the TABLE root

PIEBALDconsult 28-Oct-14 13:03pm

Ah, OK, that's easy. Wait one...

Solution 1

You can use XmlSerializer , XDocument or XmlWriter

Read this thread for more details.It explains very well about creating xml in c#

Read C# XmlWriter too

Posted 28-Oct-14 5:41am

Dilan Shaminda

v2

Comments

PIEBALDconsult 28-Oct-14 12:35pm

XmlWriter can do it only if you use System.Xml.ConformanceLevel.Fragment -- because it's not a document.

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)

PIEBALDconsult · Accepted Answer · 2014-10-28T07:08:00

C#

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.AppendChild(xmlDoc.CreateElement("TABLE"));  // DocumentElement
XmlElement rootNode = xmlDoc.CreateElement("RECORD");
xmlDoc.DocumentElement.AppendChild(rootNode);       // DocumentElement

int dbIndex = 0;
foreach (ColumnMapping columnMapping in columnMappings)
{
  XmlNode userNode = xmlDoc.CreateElement("FIELD");
  XmlAttribute attribute = xmlDoc.CreateAttribute("ID");
  attribute.Value = dbIndex.ToString();
  userNode.Attributes.Append(attribute);
  rootNode.AppendChild(userNode);
  dbIndex++;
}

rootNode = null;                                // needless
rootNode = xmlDoc.CreateElement("ROW");
xmlDoc.DocumentElement.AppendChild(rootNode);   // DocumentElement

How to create xml using c#

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us