Bind dropdown which takes value from different tables.

See more:

ASP.NET

hi I am having problem to bind a drop down, which will show values from Employeedesc column in Person table but i want it to be selected on the basis of employeeid which is in the Employee table.
To be precise my first datalevel operation would be:

select employeeid from employee where employeeeid can be in(1,2,3)

now ,if it is 1 then the employee desc from Person table should be dispalyed in the Dropdown.It will be non-editable.
the real scenario is :
i have two pages:
Employee and Person.
in employee page the user enters the employeeid.
now if he goes in Person page he can see the EmployeeDesc.
can someone please help....