Treeview + DB | SQL requests for filter data

In my ASP.net MVC project I have problems with implementation of TreeView (with Checkbox) which connected with Database.

QUESTIONS:

1) How to realise Treeview with such structure as in the second picture?! I am really confused with right SQL requests.

2) Is it possible to use a pure sql query for CheckBoxes in Treeview below to filter the table. For example the second checkbox corresponds to the query:

select termID, termCode, termname
from coltermtree, terms
where  coltermID=30 and parentnodeID=10

I just want to say that when user choose CheckBoxs which he want and click "Search" button he will see information from DB tables in "Content" block.

In the picture below you can see the structure of database:

Treeview (with CheckBox) must be like this (RESULT):