VB.NET Access 2007 Hierarchical TreeView

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

Popular posts from this blog

Visual Basic Online Courses DataGridView Add Edit Delete

Image
VB .NET DataGridView Add Edit Delete Manipulate DataGridView from Visual Basic 2010 with SQL Server Visual Basic Online Course - DataGridview SQL Server Database Note :   If you don't know how to work SQL Server With VB .NET : You need to see  this  then  this Logic Using DataGridView Control In VB .NET to Add New - Edit - Delete from/to SQL Server Database or MS-Access or any other Database type. You will find in the end of the lessons the project to download along with source code .  Design 1) Create a new Visual Basic project (Windows Application) name it as (MyDg1) and save it to your hard drive. 2) Place a DataGridView Control on the Form1. 3) Create SQL Server Database file, name it (MyDB) 4) Create Table, name it (Kinds) with just one record, name it (Kinds) 5) Rename the DataGridView Control's name From (DataGridView1) to (DG1) 6) Save/Build the project . 7) Now you have: A project such as this one in the 3 photos (from insid
Continue Reading >>

VB .NET WebView2 WinForms tips

Image
VB .NET WebView2 WinForms Tips Edge WebView2 Tips Edge WebView2 Intro This course blog discusses dealing with Microsoft Edge WebView2 Control. If you are a developer then I'm sure you have searched before for an alternative WebBrowser Control, especially if you are a Desktop Apps Developer. Edge WebView2 Control by Microsoft gives you the ability to Embed Web Technologies like (HTML, CSS, JavaScript, …, etc.) in your App. It uses rendering engine Microsoft Edge (Chromium), so you can Display the web contents in your Apps. Requirements In order to start Microsoft Edge WebView2 for Desktop Projects as alternative for WebBrowser Control, you need the following : Microsoft Windows (In my case, it is Win10 64bit) Microsoft Visual Studio (In my case, it is VS2017) WebView2 Runtime or any Microsoft Edge (Chromium) non-stable channel installed on supported OS (currently Windows 10, Windows 8.1, and Windows 7). (In my case, Win10 64bit and Microsoft Edge (Chromium)
Continue Reading >>

Visual Basic 2010 Working With DataBase Full Project Example

Image
VB 2010 Book Working With Database Full Project Example Download VB 2010 Book to work with MS-Access Book Link via MediaFire.com The book is 5 chapters and is explained here, it contains source code of a project example on how to work with Microsoft Access Database from Visual Basic 2010 .     In the book; the photos show how to start your project, how to select your database and how to display it. Here, we'll discuss each photo and explain each code block. Chapter#1 - Released VB .Net 2010 Working With DataBase Full Project Example     Photo (1) : Shows the folder that contains the project, the (My-First-Con.vbproj) is the icon you need to click to open the project.     Photo (2) : From menu (Data) choose ( Add New Data Source ), a popup dialog-box will show titled (Choose a Data Source Type) and you select (Database) as long as we are connecting to one, then click next.     Photo (3) : A popup dialog-box appears titled (Data Source Configuration) an
Continue Reading >>

VB NET Check internet connection

Image
 Check Internet Connection using VB 2010 Using VB.NET to check Internet Connection status This is a very simple example of how to check if there is an internet connection available for your machine (LapTop, PC) using VB 2010 Programming Language . - Project Design : 1) Create new project, (save it) 2) Create new Windows Application form (Form1) 3) Place a Label (Label1) and Timer (Timer1) on your Form (Form1). VB.NET Check Internet Connection - Coding In the following VB.NET Code I'm using two Functions to ( Boolean ) : Check internet connection using  Computer.Network.Ping( "google.com" ) Check internet connection Using stream = client.OpenRead( "http://www.google.com" ) ♥ Here are some online Visual Basic lessons and courses : Visual Basic .Net snippets collection Visual Basic .Net - How to check for the internet connection Visual Basic .Net - POP3 and Receiving E-mails Visual Basic .Net - Generate Random Combi
Continue Reading >>

Visual Basic .Net - Button Sound / Music Play

Image
Visual Basic 2010 - Button Sound Visual Basic 2010 - Play sound on buttons The code is simply goes like this You can copy and paste in your (Click_Event) or whatever it is you wish (MouseClick - MouseHover - MouseLeave) : Dim  MySound  As   New  System.Media.SoundPlayer()     MySound.SoundLocation =  "path to the .Wav file" MySound.Load() MySound.Play() ' OR you can use this : Sub PlaySystemSound() My.Computer.Audio.PlaySystemSound( System.Media.SystemSounds.Asterisk)   End Sub Background playing   It lets the application execute other code while the sound plays. The My.Computer.Audio.Play method allows the application to play only one background sound at a time; when the application plays a new background sound, it stops playing the previous background sound. You c
Continue Reading >>

Visual Basic 2010 Math Functions

Image
Microsoft Visual Basic 2010 Math Functions Visual Basic 2010 Math functions Math and String Functions In addition to performing simple arithmetic and string operations with the arithmetic and string operators, Visual Basic programs can take advantage of several built-in  mathematical functions  and  string functions to perform useful processing that, otherwise, could require highly complex original code. Mathematical Functions Popular mathematical functions are summarized in the following table. Note that certain functions do  not  require the  Math.  prefix. Function Use Math.Abs() Returns the absolute value. Math.Abs(-10)  returns  10 . Math.Ceiling() Returns an integer that is greater than or equal to a number. Math.Ceiling(5.333)  returns  6 . Fix() Returns the integer portion of a number. Fix(5.3333)  returns  5 . Math.Floor() Returns an integer that is less
Continue Reading >>