I have a really stupid question, but why is this SELECT not working with my cmbClient.SelectedValue? I've done this 100 times, and now getting an error saying "Operator '&' is not defined for string "SELECT ProjectID, UserID, Name F" and type 'DataRowView'."
Dim sConn As String = strConnectionString
Dim myConn As New SqlConnection(sConn)
Dim sSQL As String = "SELECT ProjectID, UserID, Name FROM Ryhal_Tickets_Projects WHERE UserID = '" & cmbClient.SelectedValue & "'"
Dim myCommand As New SqlCommand(sSQL, myConn)
myCommand.CommandText = sSQL
Dim dr As SqlDataReader
Dim dt As New DataTable
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While dr.Read
cmbProject.DataSource = dt
cmbProject.DisplayMember = "Name"
cmbProject.ValueMember = "ProjectID"