private void LoadCheckbook() { treeManagement.Nodes.Clear(); TreeNode summaryNode = treeManagement.Nodes.Add("Accounts Summary"); summaryNode.Tag = "all_summary"; string sql = "select * from accounts order by account_name"; OleDbCommand selectCmd = new OleDbCommand(sql, m_dbConnection); OleDbDataReader dataReader = selectCmd.ExecuteReader(); while(dataReader.Read()) { Account rec = new Account(); rec.Load(dataReader); m_accountRecs[rec.AccountNumber] = rec; TreeNode accountNode = treeManagement.Nodes.Add(rec.AccountName); accountNode.Tag = rec.AccountNumber; TreeNode node = accountNode.Nodes.Add("Registry"); node.Tag = "registry"; node = accountNode.Nodes.Add("Reconcile"); node.Tag = "reconcile"; node = accountNode.Nodes.Add("Archived"); node.Tag = "archived"; } dataReader.Close(); sql = "select * from businesses order by business_name"; selectCmd = new OleDbCommand(sql, m_dbConnection); dataReader = selectCmd.ExecuteReader(); while (dataReader.Read()) { Business rec = new Business(); rec.Load(dataReader); m_businessRecs[rec.BusinessName] = rec; TreeNode businessNode = treeManagement.Nodes.Add(rec.BusinessName); businessNode.Tag = "business"; TreeNode node = businessNode.Nodes.Add("Ledger"); node.Tag = "ledger"; node = businessNode.Nodes.Add("Mileage"); node.Tag = "mileage"; } dataReader.Close(); treeManagement.SelectedNode = summaryNode; }