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  

public partial class TreeDisplay : Form  
    {  
        public string Filename  
        {            get { return filename; }        }  
        protected string filename;  
        //Declaring constructor of the Class  
        public TreeDisplay()  
        {  
            InitializeComponent();  
            this.Text = "Tree View of XML File";//Form Title.  
        }//TreeDisplay Constructor  
        private void initiatingTree(string nameofFile)  
        {  
            try 
            {              
                treeView1.Nodes.Clear();  
                if (xmlDocument.DocumentElement != null) treeView1.Nodes.Add(new TreeNode(xmlDocument.DocumentElement.Name));  
                //Creating TreeNode and adding the first node to it.  
                TreeNode tNodeObj = treeView1.Nodes[0];  
                                 
                XmlNode xNode = xmlDocument.DocumentElement;  
 
                //Declaring function for adding Nodes to tree View.  
                AddingNodesToTree(xNode,tNodeObj);  
                toolStripStatusLabel1.Text = "Opened file " + nameofFile;  
                treeView1.Nodes[0].Expand();  
                treeView1.CollapseAll();  
            }//try block ends  
            //Exception Handlers to catch any sort of error  
            catch (XmlException xmlex)  
            {  
                MessageBox.Show(xmlex.Message, "Error");  
            }//catch  
            catch (Exception exp)  
            {  
                txtFileName.Text = exp.Message;  
            }  
        }//initiatingTree  
private void btnBrowse_Click(object sender,EventArgs e)
        {
            bgWorker1.RunWorkerAsync();
            StripProgressBar.Value = 0;
            toolStripStatusLabel1.Text = "Browsing for a  Xml file";
            OpenFileDialog open = new OpenFileDialog();
            
            if (open.ShowDialog(this) == DialogResult.OK)
            {
                txtFileName.Text = open.FileName;
                initiatingTree(open.FileName); 
            }
            while (this.bgWorker1.IsBusy)
            {
                StripProgressBar.Increment(1);
                Application.DoEvents();
            }
        }//Browse button      
        private void bgWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            xmlDocument = new XmlDocument();
            Thread.Sleep(5000);
            xmlDocument.Load(txtFileName.Text);
            btnBrowse.Enabled = false;
        }
        private void bgworker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
         {
             StripProgressBar.Value = 100;
             if (e.Error == null)
             {
                 MessageBox.Show(xmlDocument.InnerXml, "Download Complete");
             }
             else
             {
                 MessageBox.Show("Failed to download file");                    
             }
             // Enable the Browse button and reset the progress bar.
             this.btnBrowse.Enabled = true;
             StripProgressBar.Value = 0;
             toolStripStatusLabel1.Text = "work finished processing request.";  
         }//workerCompleted  
    }// TreeDisplay Class