Here is your sql query code:
Dim MySQL As String = "Select distiller_id,distiller_name from distiller inner join station on distiller.station_id=station.station_id and distiller.station_id='& ddl.SelectedValue & ' "
You are telling the database to look for the literal string:
"& ddl.SelectedValue & "
You are simply missing 2 ":
Dim MySQL As String = "Select distiller_id,distiller_name from distiller inner join station on distiller.station_id=station.station_id and distiller.station_id='" & ddl.SelectedValue & "' "
-
Peter