populating data to dropdown list and text field from sql table

Question

Hi,

       Can you help me for populating data to dropdown list from sql server db table and when selecting the dropdown list the text box field must be loaded accordingly? 

example: If I select employee id (E0000001,.....) in ddl, the other textbox fields have to be loaded(name,department,designation,...)