Loading

Where is the wrong in this SQL Query?

giannis papas

13y1.1kSQL

Hi guys

Can anyone tell me where is the wrong in this SQL Query?

Dim selectedCompany As String = cbCompany.SelectedValue
cm = New SqlCommand("Select distinct City From Staff Where Company='" + selectedCompany + "'", cn)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
I can't see anything wrong with the query itself but I'd have though that the first line should either be:

Dim selectedCompany As String = cbCompany.SelectedValue.ToString()

or if, you want to use what's actually displayed in the ComboBox:

Dim selectedCompany As String = cbCompany.SelectedItem.ToString()