I am trying to populate a gridview with all the rows from a database until someone selects a value from a dropdownlist. I added a list item to the dropdownlist control named Choose City value is everything.

How do I put job_city = everything into the code below?

Public Function getJobsBySelectedCity(ByVal job_city As String) As Northwind.productsDataTable

If job_city = what code goes here Then

 Return getproducts()

Else

Return Adapter.GetJobsBySelectedCity(job_city)

End If



Any advise?