C#

private void AddNodesToTree(XmlNode currentXMLNode, TreeNode currentTreeNode)
{

    // Loop through the XML nodes until the leaf is reached.
    // Add the nodes to the TreeView during the looping process.
    if (currentXMLNode.HasChildNodes == true)
    {
        XmlNodeList XMLChildNodeList = currentXMLNode.ChildNodes;
        XmlNode XMLChildNode;
        TreeNode TreeChildNode;
        int NodeIndex = 0;

        for (int i = 0; i < XMLChildNodeList.Count; i++)
        {
            if ((XMLChildNodeList.Item(i).GetType().ToString() != "System.Xml.XmlComment") && 
                (XMLChildNodeList.Item(i).GetType().ToString() != "System.Xml.XmlText"))
            {
                XMLChildNode = currentXMLNode.ChildNodes[i];

                if (XMLChildNode.Attributes.Count != 0)
                {
                   currentTreeNode.Nodes.Add(XMLChildNode.Attributes.Item(0).InnerText);
                }
                else
                {
                   currentTreeNode.Nodes.Add(XMLChildNode.Name);
                }

                TreeChildNode = currentTreeNode.Nodes[NodeIndex];
                NodeIndex++;
                AddNodesToTree(XMLChildNode, TreeChildNode);
            }
        }
    }
    else
    {
        // Here you need to pull the data from the XmlNode based on the
        // type of node, whether attribute values are required, and so forth.
        currentTreeNode.Text = (currentXMLNode.OuterXml).Trim();
    }
}

<br />
<br />
    string server = "Server=http://www.somepage.org.nz;Database=somedatabase;Uid=myusername;Pwd=mypassword";<br />
    MySqlConnection con = null;<br />
    try<br />
    {<br />
        con = new MySqlConnection(server);<br />
        con.Open();<br />
        this.label1.Text = con.State.ToString();<br />
    }<br />
    catch (Exception ex)<br />
    {<br />
        this.label1.Text = ex.Message;<br />
    }<br />