I am using ASPxTreeList
I want to Bind a dropdownlist
Example

Table structure

ID      ParentID        Name                    Country                  States
1        NuLL        FullName             Country of Origin           State
2         1               John                        USA                          OH
3         2               Jim                          USA                           OH
4         2               Brian                       USA                           MD
5         1              Samantha                USA                           VA
6         1              Joss                         Canada                     Van
7         6              Ron                         Canada                      Tor
8         1              Katie                        UK                              Lon
9         1              Carmen                   Germany                    Ber

Now For examle,

When I clik on Edit  or Insert

On first row

I need to display all the list of countries and text box

 in Row 2 or 3 or 4

FullName = textbox
Country of Origin = (USA Only) as the children Id's 3 and 4 belongs to Parent ID 2)
State = textBox

Similarly When i click on Edit or insert on Row 6 it should display Canada only in dropdown list...
similar with other rows..

If someone can provide me some example..

we are planing to buy this tools if we can successfuly implement our business requiremnet.

Thanks..

PS: I am using Sqldatabase