Need to populate GridDropDown except itself.

[nagarjun]

Hi all,

        In my project i am using GridDropDownColumn in RadGrid. In this i want to populate data from database. The relationship in database is one column contains Names and the other column contains the parentName, which is one of the first column.

       So, in this GridDropDown i need to populate parentName column, but the Name belonging to parentName i should not populate it.

    Name       ParentName

      a             b

       b c

c a

d f

e d

f d

     This is the example i have shown. When i expand the GridDropDownColumn of first row i have to get all items in Name except "a" item. Because it can not be itself to parent.

 Thanks,

Nagarjun S.