Dynamic TreeGrid Data Table

Himanshu89

Dear Sir,
I want to generate datatable as shown in attached file.
I have following Hierarchy structure.
Country->State->District->Village
also find below sample queries.
1)Query1- select country_name,count from demoTable;
2)Query2- select state_name,count from demoTable where country_name=?;
3)Query3- select Discrtict_name,count from demoTable where country_name=?,state_name=?;
4)Query4- select Village_name,count from demoTable where country_name=?,state_name=?,Discrtict_name=?;

when I click on '+' sign of Country1 ,Query1 will be fired & table should be expanded to state1,state2 & state3 depending on dynamic results of Query1

when I click on '+' sign of State1 ,Query2 will be fired & table should be expanded to District1 & District2 ,In this way all levels will be opened.

Pl note each query should be fired when we click on '+' sign.

Kindly also suggest any events so that I can call Ajax.