Database to Gridview via Dropdown list

I would like to be able to select a text form a drop down list and retrieving corresponding data to showing it in a row on a Grid-view. Is this doable? How can i access the text hat is selected? How do I show it on the gridview?