Response to: Trying to use drop down list as filter

Revision 4
You have not executed the query or added the connection property. Add this to your code:

Dim command As New SqlCommand("select * from grades where test = " Convert.ToString(Me.DropDownList2.SelectedValue), con)


Dim reader as SqlDataReader

reader = command.ExecuteReader();

Also, remove the "command' variable from the DataAdapter constructor.