C#

string sAppPath = (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).Replace("file:\\", "");
public System.Data.OleDb.OleDbConnection DBConnection = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + (sAppPath + "\\Database.mdb"));

sSQLStatement = ("SELECT Filename FROM Scriptures");
System.Data.OleDb.OleDbCommand SQLCommand = new System.Data.OleDb.OleDbCommand(sSQLStatement, DBConnection);

try
{
    if (DBConnection.State.ToString() == "Closed") DBConnection.Open();

    // Create the datareader object to connect to table
    System.Data.OleDb.OleDbDataReader DataReader = SQLCommand.ExecuteReader();

    // Did we get anything?
    while (DataReader.Read())
    {
        // Do some manipulation
    }

    // Close the reader 
    DataReader.Close();

    // Close the connection. Its important.
    DBConnection.Close();
}

if (DBConnection.State.ToString() == "Closed") DBConnection.Open();

public partial class TreeDisplay : Form     
    {     
        public string Filename     
        { get { return filename; }        }     
        protected string filename; 
        private void initiatingTree(string nameofFile)     
        {     
         treeView1.Nodes.Clear();     
         if (xmlDocument.DocumentElement != null) treeView1.Nodes.Add(new TreeNode (xmlDocument.DocumentElement.Name));     
                TreeNode tNodeObj = treeView1.Nodes[0];     
                XmlNode xNode = xmlDocument.DocumentElement;     
                AddingNodesToTree(xNode,tNodeObj);     
                treeView1.Nodes[0].Expand();     
                treeView1.CollapseAll();                
        }//initiatingTree     
        //Method to add Nodes to tree     
        private static void AddingNodesToTree(XmlNode xmlNode,TreeNode tnode)     
        {  //Adding nodes to tree while looping through the entire XML file     
            if (xmlNode.HasChildNodes)     
            {   
                XmlNodeList nodeList = xmlNode.ChildNodes;                    
                for (int i = 0; i <= nodeList.Count - 1; i++)     
                {   XmlNode xmladdtreeNode = xmlNode.ChildNodes[i];     
                    String nodetype = "" + xmladdtreeNode.NodeType;     
                    if (nodetype.Equals("Text") || nodetype.Equals("Comment"))   
                    {     
                     tnode.Nodes.Add(new TreeNode(xmladdtreeNode.InnerText));               
                    }     
                    else    
                      {   
                        String name = "<" + xmladdtreeNode.Name;     
                        XmlAttributeCollection attCol = xmladdtreeNode.Attributes;    
                        foreach (XmlAttribute xmlatt in attCol)     
                        {     
                        name += " " + xmlatt.Name + "=\"" + xmlatt.Value + "\"";     
                        }     
                        name +=  ">";     
                        TreeNode tn = new TreeNode(xmladdtreeNode.Name);     
                        tn.Text = name;     
                        tnode.Nodes.Add(tn);     
                        TreeNode treeNode = tnode.Nodes[i];     
                        AddingNodesToTree(xmladdtreeNode,treeNode);     
                        }     
                }//for     
            }//if     
          else    
            {  tnode.Text = xmlNode.OuterXml.Trim();     
            }//else      
        }//AddingNodesToTree     
        private void treeView1_AfterSelect(object sender,TreeViewEventArgs e)     
        {     
            listBox1.Items.Clear();     
            TreeNode treenode = e.Node;   //Node selected in Treeview               
            String text = treenode.Text;     
            String relevent = text;     
            Boolean flag = true;     
            while (flag)     
            {   int SpaceIndex = relevent.IndexOf(" ");     
                if (SpaceIndex != -1)     
                {   int indexofEqual = relevent.IndexOf('=', SpaceIndex);     
                    if (indexofEqual != -1)     
                    { int indexOFValue = relevent.IndexOf("\"", indexofEqual + 2);     
                        if (indexOFValue != -1)     
                        { 
 String attribute = relevent.Substring(SpaceIndex + 1, indexofEqual - SpaceIndex - 1);      
   String value = relevent.Substring(indexofEqual + 2, indexOFValue - indexofEqual - 2);     
         listBox1.Items.Add("Attribute:" + attribute + "Value:" +value);                     
                     releventreleventreleventrelevent = relevent.Substring(indexOFValue);   
                        }   
                        else   
                        {  listBox1.Items.Add("Bad format of the xml file for this node");   
                            flag = false;   
                        }  }   
                    else   
                    {    flag = false;   
                    }   }   
                else   
                {   flag = false;     }   
            }   }//AfterSelect()          
         }// TreeDisplay Class