Where is the wrong in this SQL Query?

Question

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)

Vulpes · Answer

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()