method1:
public static string GetXMLNode(string xmlName,string xmlpath,string key)
{
XmlDocument document = new XmlDocument();
string str = xmlpath + "//" + xmlName + ".xml";
string text1, text2;
document.Load(str);
XmlNodeList nodelist = document.GetElementsByTagName("*");
XmlElement element;
text1="";
text2="";
for (int i = 0; i < nodelist.Count; i++)
{
element = (XmlElement)nodelist[i];
if (element.Name=="Part")
{
text1 = element.GetAttribute("pgid");
}
if (element.Name == "SQLQuery")
{
text2 = element.GetAttribute("id");
}
if (element.GetAttribute("id") == key)
{
str = element.InnerText;
break;
}
}
return str;
}
#endregion
method2:
XmlDocument document = new XmlDocument();
IEnumerator enumerator1 = null;
XmlNode node1;
XmlElement element1 = null;
XmlElement elementChild = null;
IEnumerator enumeratorChild = null;
string str = xmlpath + "//" + xmlName + ".xml";
document.Load(str);
enumerator1 = document.DocumentElement.ChildNodes.GetEnumerator();
while (enumerator1.MoveNext())
{
node1 = (XmlNode)enumerator1.Current;
if (node1 is XmlElement)
{
element1 = (XmlElement)node1;
if ("Part".Equals(element1.Name))
{
enumeratorChild = null;
enumeratorChild = element1.ChildNodes.GetEnumerator();
while (enumeratorChild.MoveNext())
{
node1 = (XmlNode)enumeratorChild.Current;
if (node1 is XmlElement)
{
elementChild = (XmlElement)node1;
if ("SQLQuery".Equals(elementChild.Name))
{
str = elementChild.InnerText;
}
}
}
}
}
}
return str;