urgenttttttt to populate a treeview by getting the data from the database

[rahul_0716]

to populate a treeview by getting the data from the database

i have threee tables

table1: Maincountry

columns: id,Countryname

 

table2: Country

columns: country,state

 

 

table2: State

columns: state,cities

 

i want the tree view to be like this

 

-country1

-State1

-city1

-city2

-state2

-city1

-city2

-country2

-State1

-city1

-city2

-state2

-city1

-city2

 

what is to be done i want the code please its urgentttttt

 

thanks in advance