How to update gridview values based on SQL-integrated ddl

I need my gridview table to update its values based on the value selected in drop down list. My drop down list is associated with SQL table. Gridview table should display "Open" help desk tickets when "Open" value is selected in drop down list, and then should display "Closed" help desk tickets when "Closed" value is selected in drop down list. Thanks!