Adding element to existing XML node

Question

Where am i going wrong???

I have an xml file with OppDetails as a tag already as shown below

<OppDetails>
  <OMID>245414</OMID> 
  <ClientName>Best Buy</ClientName> 
  <OppName>International Rate Card</OppName> 
  <CTALinkType>AO,IO,MC,TC</CTALinkType> 
  </OppDetails>
  </OppFact>

Now i am trying to add another element to it but getting an error in AppendChild method please help

XmlNode rootNode = xmlDoc.SelectSingleNode("OppDetails");
XmlElement xmlEle = xmlDoc.CreateElement("CTAStartDate");
xmlEle.InnerText = ExcelUtility.GetCTAStartDate();
rootNode.AppendChild(xmlEle);
            xmlDoc.Save("C:\\test.xml");

It would help to know what the error is.

EMP
– EMP

2010-04-19 03:39:01 +00:00
Commented Apr 19, 2010 at 3:39 — EMP
– EMP, Commented Apr 19, 2010 at 3:39
Object reference not set to an instance of an object.

SSK
– SSK

2010-04-19 03:42:06 +00:00
Commented Apr 19, 2010 at 3:42 — SSK
– SSK, Commented Apr 19, 2010 at 3:42

SSK · Accepted Answer · 2010-04-19 04:03:36Z

3

XmlElement xmlEle = xmlDoc.DocumentElement["OppDetails"];
XmlElement eleNew = xmlDoc.CreateElement("CTAStartDate");
eleNew.InnerText = ExcelUtility.GetCTAStartDate();
xmlEle.AppendChild(eleNew);
xmlDoc.Save("C:\\test.xml");

edited Apr 19, 2010 at 4:03

answered Apr 19, 2010 at 3:55

SSK

8033 gold badges19 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

John Saunders Over a year ago

Is this the solution to the problem?

Jon Peterson Over a year ago

It would be helpful to mark this as the accepted answer. Also, if you could provide any details as to why you were able to get this to work when your previous attempt failed it would help others.

Marc Gravell · Accepted Answer · 2010-04-19 04:13:05Z

2

It is hard to tell without a full sample, but a common reason for SelectNodes / SelectSingleNode returning null is xml namespaces. If you xml makes use of element namespaces, you'll probably need to use an XmlNamespaceManager along with your query, and define a suitable alias for the namespace you want.

answered Apr 19, 2010 at 4:13

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Comments

Zach Johnson · Accepted Answer · 2010-04-19 03:53:26Z

0

Is rootNode null?

From MSDN on SelectSingleNode:

The first XmlNode that matches the XPath query or a null reference (Nothing in Visual Basic) if no matching node is found.

If rootNode is null, it indicates that the node could not be found, and trying to use the null rootNode would cause the exception you are seeing.

answered Apr 19, 2010 at 3:53

Zach Johnson

24.3k7 gold badges71 silver badges86 bronze badges

Comments

John Saunders · Accepted Answer · 2010-04-19 03:54:29Z

0

The exception you've reported means that you have not located the root element. When SelectSingleNode can't find the requested node, it returns null. You didn't check for that.

answered Apr 19, 2010 at 3:54

John Saunders

162k26 gold badges252 silver badges403 bronze badges

Comments

Navin Pandit · Accepted Answer · 2016-12-28 11:08:17Z

0

Read root node and add the new element in to the root node. I think you are trying to append in XML document.

answered Dec 28, 2016 at 11:08

Navin Pandit

1892 silver badges8 bronze badges

1 Comment

ρяσѕρєя K Over a year ago

This should be a comment.

Collectives™ on Stack Overflow

Adding element to existing XML node

5 Answers 5

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related