XML / XSL

public static System.Xml.XmlNamespaceManager
GetNamespaceManager
(
    System.Xml.XmlDocument Document
)
{
    System.Xml.XmlNamespaceManager result =
        new System.Xml.XmlNamespaceManager ( Document.NameTable ) ;

    System.Xml.XmlNodeList nodes = Document.DocumentElement.SelectNodes ( "//*" , result ) ;

    foreach
    (
        System.Xml.XmlNode nod
    in
        nodes
    )
    {
        foreach ( System.Xml.XmlAttribute att in nod.Attributes )
        {
            if ( att.Prefix == "xmlns" )
            {
                result.AddNamespace ( att.LocalName , att.Value ) ;
            }
        }
    }

    return ( result ) ;
}

XmlNamespaceManager nsmgr = new XmlNamespaceManager( Document.NameTable );
XPathNavigator nav = Document.CreateNavigator();
nav.MoveToFollowing( XPathNodeType.Element );
foreach (var ns in nav.GetNamespacesInScope( XmlNamespaceScope.ExcludeXml ))
{
    nsmgr.AddNamespace( ns.Key, ns.Value );
}

XmlDocument xmlDoc =new XmlDocument;
xmlDoc.Load("C:\MyXml");
string myXPath="/Root/Data[@Gender='Male']";  //so with this you can get only male nodes

XmlNodeList NodeList=xmlDoc.SelectNodes(myXPath);  //Selects all the male nodes

XmlNode xmlNod=NodeList(0); //The first male node

Int myId=xmlNod.Attributes("id").Value; //Returns the id of the first Male node

format-number(".//AmountPaid","#.00")