Question: how to display selected value of dropdownlist into the gridview in asp.net?
Answer:  Use a global datatable variable to store the complete data. It will contain your whole database table (something like "Select * from facultymembers")
 On load, use that variable to populate a gridview, aka your table in aspx. ... 
 Attach an "onchange" event to your dropdownlist.