Author

Ahmed Samir

Evry1falls is my online name

VB.NET Access 2007 Hierarchical TreeView

VB.NET Access 2007 Hierarchical TreeView 5 of 5

VB.NET Access 2007 Hierarchical TreeView

Hierarchical TreeView
visual Basic .Net project Hierarchical TreeView


VB.NET Hierarchical TreeView 
Project requirements

  • VS 2010 / 2015
  • .Net FrameWork version 4.5 [Properties : Enable -> Make single instance application]
  • Compile option -> Target CPU : x86
  • MS Access 2007 / 2010 (*.accdb)

VB.NET Hierarchical TreeView Project logic

  • Populate Access 2007 Database Tables with Data from Visual Basic 2015 Form Controls [TextBox]
  • Display or populate TreeView control with Hierarchical Data From Microsoft Access 2007 Database (*.accdb)
  • Display or populate TreeView control (Parents / Child) with search results from Access 2007 and highlight search results.
  • Perform Insert, Update, Search, Delete commands to/from Access 2007 Database from VS 2015 Form Control MenuStrip.

VB.NET Hierarchical TreeView Project steps summary

  1. Create Microsoft Visual Basic 2015 Project [Desktop Classic] Windows Form Application Project and name it [HierarchicalTreeView.vb], one Form (MainForm.vb).
  2. Create Access 2007 Database (hierarchical.accdb) in VS 2015 Project Directory (/Bin/Debug)
  3. Create Module (Connections.vb)

VB 2015 Hierarchical TreeView Project
VB 2015 Hierarchical TreeView Project

VB.NET Hierarchical TreeView Access 2007 Database Design

  • Create three (3) tables [us_states],[us_cities],[BasicInfo]

VB 2015 Hierarchical TreeView Access 2007 2010
VB 2015 Hierarchical TreeView Access 2007 2010


VB.NET Hierarchical TreeView Access 2007 Tables relationship


VB 2015 Hierarchical TreeView with Access 2007 Relationship
VB 2015 Hierarchical TreeView with MS Access Table Relation

VB.NET Hierarchical TreeView Project Functionalities

[MainForm] 


  • Is linked to MS Access Database 2007 [hierarchical.accdb] programatically. [MainForm] form performs Save, Search, Edit, Delete, Display to TreeView Control all Data From/Into Database Tables programmatically.

[Form_Load]


  • Validate OleDBConnection with Microsoft Access 2007 Database.
  • Populate ComboBox with Data from Microsoft Access 2007 Database table [us_cities] contains 29.8k records which are all United States Cities and all the States are from table [us_states] From [BackGroundWorker_RunWorkerCompleted] event.
  • Populate TreeView Control with all Data from Microsoft Access 2007 Database table [BasicInfo] including Image, From [BackGroundWorker_RunWorkerCompleted] event.
  • Triggers [BackgroundWorker.RunWorkerAsync()] and [BackgroundWorker_DoWork] that executes all the ComboBox and TreeView Controls populations and displays both contents on MainForm after finishing their job.

[TreeView Mouse_DoubleClick]


  • Displays all Database table contents that is stored in the TreeView Control nodes on the Form's controls.

[BackGroundWorker]


  • Displays the Form and all controls while waiting for ComboBox control to load 29.8k records from Access 2007 table [us_cities] and also the TreeView Control to load all Data stored in the Access 2007 table [BasicInfo].

The MS Access 2007 Database [hierarchical.accdb] 


  • has all United States States in table [us_states], each United State's [STATE_NAME] in table [us_states] is linked to its Cities in table [us_cities]. Table [BasicInfo] is linked to table [us_cities], so each User in table [BasicInfo] is linked to [us_cities] on field [ID] as shown above.

MenuStrip [File]


  • [New] : Clears all TextBoxes and resets the TreeView Control ForeColor and BackColor.
  • [Save] : Performs Sql Statement [Insert Into] using [OleDBTransaction] after validating all controls.
  • [Search] : Searches TreeView Control and Highlights search results nodes ForeColor and BackColor.
  • [Update] : Performs Sql Statement [Update table Set ..] and displays result on TreeView and Form.
  • [Delete] : Performs Sql Statement [Delete From table ..] and displays result on TreeView Control and on form.
  • [Compact & Repair] : Reduces/compacts Microsoft Access 2007 Database file size and do Repairs, using Microsoft.Office.Interop.Access.Dao.DBEngine [version 12.0.0.0 for Access 2007] [version 14.0.0.0 for Access 2010].

VB.NET Hierarchical TreeView Project MainForm Design

VB.NET Hierarchical TreeView Project MainForm Design
VB.NET Hierarchical TreeView Project MainForm Design

In this VB.NET project example you will learn

  • Connecting MS Access 2007 Database [*.accdb] password protected to VB.NET Form programmatically using [Module].
  • Executing SQL Statements [Insert InTo, Update, Select, Delete, Select ... INNER JOIN] on Access 2007 table using VB.NET OleDB Parameters.
  • How to populate [ComboBox] Control with Data from Access 2007 Database Table using Dictionary(Of String, String)() method.
  • How to use VB.NET [BackgroundWorker] Control to display UI (MainForm) while waiting to fill ComboBox with Data from Access 2007 Database table.
  • How to show [Progressbar] Control loading action while Data from Database table is being loaded into ComboBox Control.
  • How to insert Photo/Image from [PictureBox] Control into Access 2007 table and retrieve Photo/Image from Access 2007 table to VB.NET [PictureBox] Control.
  • How to insert Custom Date Format from [DateTimePicker] Control into Access 2007 table and retrieve Date from Access 2007 table to VB.NET [DateTimePicker] Control with Custom Format.
  • How to populate [ImageList] with Images from Access 2007 Database table and use Images from VB.NET ImageList Control into TreeView Control.
  • Populate VB.NET TreeView Control with photos/images from Access 2007 table using Imagelist Keys.
  • How to use OleDBTransaction with Sql Statement Insert Into and Sql Statement Update to ensure Data were successfully inserted into Access table.
  • How to populate [TreeView] Control on VB.NET Form with Data From MS Access 2007 table.

Source Code Download





Password : projectzone.co

Comment Via facebook

Popular posts from this blog

Visual Basic Online Course DevExpress 12.2.4 full for Visual Studio 2010

Visual Basic Online Course - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

VB .NET Google Drive Api Source Code Example

Visual Basic Compare Two Treeviews and return differences

Visual Basic Online Course - SQL Server