Fetch Values from Sql

Question

how to fetch particular value from a table in sql .
I want to fetch Name when clicked on Employee Code .

for eg:
i have list of employee code in a combo Box . and when i select 101 code from list , then i should display Its name.

I