SelectNodes issue

[Lord_Rat]

At the moment I have a workaround, but this really needs solving because this is going to increase the complexity of my application.

That said, the problem:

Source XML:

<ShowParty xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xmlns:Example="http://www.example.com" revision="8.0" xmlns="http://www.openapplications.org/oagis">
	<ApplicationArea>
		<CreationDateTime>1900-10-01T14:29:30-07:00</CreationDateTime>
	</ApplicationArea>
	<DataArea>
		<Show confirm="Never" totalRecordCount="4" />
			<Party>
				<Business>
					<Name>Business One</Name>
					<UserArea>
						<Example:Telephone>5555555555</Example:Telephone>
					</UserArea>
				</Business>
			</Party>
			<Party>
				<Business>
					<Name>Business Two</Name>
					<UserArea>
						<Example:Telephone>2222222222</Example:Telephone>
					</UserArea>
				</Business>
			</Party>
	</DataArea>
</ShowParty>

Fed in to my function, I amy trying to select the value of:
DataArea/Party/Business/Name

Here is my code:

			public void GetResults(string SourceXML, stringSearchNode)
			{
				XmlDocument doc = new XmlDocument();
				System.IO.MemoryStream objDoc = new System.IO.MemoryStream(GetByteArray(SourceXML));
				doc.Load(objDoc);
				System.Xml.XmlNamespaceManager oNS = new System.Xml.XmlNamespaceManager(doc.NameTable);
				oNS.AddNamespace("Example", "http://www.example.com");

				System.Xml.XmlNodeList oNL;
				oNL = doc.DocumentElement.SelectNodes(SearchNode, oNS);
				for(int j = 0 ; j < oNL.Count ; j++)
				{
					Debug.WriteLine(oNL[j].InnerText);
				}
			}



			public static byte[] GetByteArray(string sIn)
			{
				byte[] oTmp = new byte[sIn.Length];
				for(int i = 0 ; i < sIn.Length ; i++)
				{
					oTmp[i] = (byte)(sIn.Substring(i, 1).ToCharArray(0, 1)[0]);
				}
				return oTmp;
			}

Well, it doesn't select any nodes at all if I call the function like this:
GetResults(sSourceXML, "DataArea/Party/Business/Name") /* sSourceXML is the original XML as a string */

But if I call it like this, it does work:
GetResults(sSourceXML, "*[name()='DataArea']/*[name()='Party']/*[name()='Business']/*[name()='Name']")

But that second method was after a half a day working at this issue and is basically a hack. What I discovered was that I was able to select any node I wanted if I used the '*' wildcard to select nodes, but as soon as I was specific about a node's name, it would not return any nodes, ever.