C # parsing xml c and apostrophe exception

Question

I am parsing an xml file and run into a problem when trying to find a node that has an apostrophe in it. When the element name does not have this, everything works fine. I tried replacing the apostrophe with different escape characters, but I was not very lucky

string s = "/itemDB/item[@name='" + itemName + "']";

// Things i have tried that did not work
// s.Replace("'", "''");
// .Replace("'", "\'");

XmlNode parent = root.SelectSingleNode(s);

I always get an XPathException. What is the right way to do this. Thanks

Answer 1

You can do it:

XmlDocument root = new XmlDocument();

root.LoadXml(@"<itemDB><item name=""abc'def""/></itemDB>");

XmlNode node = root.SelectSingleNode(@"itemDB/item[@name=""abc'def""]");

Note the shorthand literal '@' and double quotes.

Then your code will look like this and nothing needs to be replaced:

var itemName = @"abc'def";

string s = @"/itemDB/item[@name=""" + itemName + @"""]";

Answer 2

To apostop, replace it with '