XML / XSL

<?xml version="1.0" encoding="UTF-8" ?><br />
<xsl:stylesheet <br />
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
  version="1.0" ><br />
<br />
  <xsl:param name="column_name">object_NAME</xsl:param><br />
<br />
  <xsl:template match="/"><br />
    <xsl:value-of select="//table/*[name() = $column_name]/text()"&/><br />
  </xsl:template><br />
<br />
</xsl:stylesheet>

XslTransform xslt = new XslTransform();<br />
XmlDocument document = new XmlDocument();<br />
document.LoadXml(xmlFileName);<br />
xslt.Load(stylesheetFileName);<br />
<br />
MemoryStream ms = new MemoryStream();<br />
XPathNavigator nav = document.CreateNavigator();<br />
<br />
XsltArgumentList xslArg = new XsltArgumentList();<br />
<br />
xslArg.AddParam("column_name", "", "name of column you want");<br />
<br />
xslt.Transform(nav, xslArg, ms, null);<br />
<br />
// output to a stream<br />
StreamReader sr = new StreamReader(ms);<br />
ms.Position = 0;<br />
string result = sr.ReadToEnd();<br />
sr.Close();

---

"When the only tool you have is a hammer, a sore thumb you will have."

---

"When the only tool you have is a hammer, a sore thumb you will have."

XmlNodeList results = document.SelectNodes(""//root/bla");<br />
foreach (XmlNode result in rtesults)<br />
{<br />
  Console.Write("found {0} value = '{1}'", GetNodeName(result), result.value);<br />
}<br />
<br />
string GetNodeName(XmlNode node)<br />
{<br />
  string result = node.LocalName;<br />
<br />
  if (node.Parent != null)<br />
    result = GetNodeName(node.Parent) + "/" + result;<br />
<br />
  return result;<br />
}

<br />
string GetNodePosition(XmlNode node)<br />
{<br />
  int previousSiblings = 0; <br />
  for (XmlNode previous_node = node.PreviousSibling; previous_node != null; previous_node = previous_node.PreviousSibling)<br />
    previousSiblings++;<br />
  string result = previousSiblings.ToString();<br />
<br />
  if (node.Parent != null)<br />
    result = GetNodeName(node.Parent) + "/" + result;<br />
<br />
  return result;<br />
}

---

"When the only tool you have is a hammer, a sore thumb you will have."

<?xml version="1.0" encoding="utf-8" ?><br />
<xs:schema id="GeneralFormatting" <br />
targetNamespace="http://localhost/XMLWebServices/GeneralFormatting.xsd"<br />
elementFormDefault="qualified"<br />
xmlns:ns="http://localhost/XMLWebServices/GeneralFormatting.xsd"<br />
xmlns:xs="http://www.w3.org/2001/XMLSchema"><br />
<br />
  <!-- Define format restriction -->  <br />
  <xs:simpleType name="UserName"><br />
    <xs:restriction base="xs:string"><br />
      <xs:pattern value="([a-zA-Z0-9])*"></xs:pattern><br />
      <xs:whiteSpace value="preserve" /><br />
    </xs:restriction><br />
  </xs:simpleType><br />
</xs:schema><br />

<?xml version="1.0" encoding="utf-8" ?><br />
<xs:schema id="WTNManagement_XSD" <br />
  targetNamespace="http://localhost/XMLWebServices/Management.xsd" <br />
  elementFormDefault="qualified" <br />
  xmlns:tns="http://localhost/XMLWebServices/Management.xsd"<br />
  xmlns:gns="http://localhost/XMLWebServices/GeneralFormatting.xsd"  <br />
  xmlns:xs="http://www.w3.org/2001/XMLSchema"><br />
<br />
<xs:import <br />
  schemaLocation="http://localhost/XMLWebServices/GeneralFormatting.xsd" /><br />
<br />
  <!-- definition of elements --><br />
  <xs:element name="Management" id="Management"><br />
    <xs:complexType><br />
      <xs:sequence><br />
        <!-- File Sequence number, must be unique --><br />
        <xs:element name="SeqNum" type="xs:integer" /><br />
        <!-- User making request --><br />
        <xs:element name="UserName" type="gns:UserName" /><br />
      </xs:sequence><br />
    </xs:complexType><br />
  </xs:element><br />
</xs:schema>

<br />
Type ‘http://localhost/XMLWebServices/GeneralFormatting.xsd:UserName’ is not declared. An error occurred at ... <br />

---

"When the only tool you have is a hammer, a sore thumb you will have."