Tree View Main, sub, and sub-sub nodes from sql db table

Question

Hi I'm new to c#, and trying to learn this for an application that I'm building. 

 

I have a tree view with the following Nodes in it

 

Folder

            Year

                     File 

I have 1 table that I'm adding the data too.

 

I would like to know how I can get a single folder of a listed FolderName vs multiple folders (of the same Folder), same thing for year, and then finally list the filenames, under that folder for that year.