How to Make Relation Between different DropDownLists

See more:

C#

ASP.NET

Hi,
I have a table with 4 columns, and i am binding these columns to different DropdownLists. I need to get that, if i change any dropdownlist value, the remaining dropdwonlist should effect with that respected row.
I have table Like this,

id	Name	FatherName	MotherName
1	Name1	Father1 	Mother1
2	Name2	Father2 	Mother2
3	Name3	Father3 	Mother3
4	Name4	Father4 	Mother4

DropDownList1 is Bind with first Column (id),
DropDownList1 is Bind with second Column (Name),
..
..and so on..

If i select id as 1, the Dropdownlist2 should auto select to Name1, and DropDownList3 is to Father1...and so on..

if i change dropdownlist2 value, same as above remaining dropdownlists should effect..

How can i get it by using Apc.net(C#)..

Please help..