DropDown List Selection to Populate TextBox

How do i display sql data in the textfield based on selection. How can i display SQL data in the textfield box based DropDown selection. 
I want to display student first_name,last_name,dept on textfield box based on their ID number from DropDown selection.
How can i do that with ASP.NET?
...