ExecuteReader: Connection property has not been initialized

[11Mercenary]

Hello, I'm using a combobox in vb 2010 and I got this code and i'm getting an error on my connection. Could someone please tell me why am i getting this kind of error and how to fix it?
Thank you.

Private Sub cbPlayer9_DropDown(sender As Object, e As System.EventArgs) Handles cbPlayer9.DropDown
        Dim con As New SqlClient.SqlConnection
        con.ConnectionString = My.Settings.MyConnectionString
        Dim Query As String = "SELECT Nickname FROM Player WHERE Nickname not like '" & cbPlayer0.Text & "' AND Nickname not like '" & cbPlayer1.Text & "' AND Nickname not like '" & cbPlayer3.Text & "' AND Nickname not like '" & cbPlayer4.Text & "' AND Nickname not like '" & cbPlayer5.Text & "' AND Nickname not like '" & cbPlayer6.Text & "' AND Nickname not like '" & cbPlayer7.Text & "' AND Nickname not like '" & cbPlayer8.Text & "' AND Nickname not like '" & cbPlayer2.Text & "'"
        Dim cmdselect As New SqlCommand
        Dim ds As New DataSet()
        Dim dt As DataTable
        Dim read As SqlDataReader
 
        con.Open()
        read = cmdselect.ExecuteReader()
 
        dt = New DataTable("Player")
        ds.Tables.Add(dt)
        ds.Load(read, LoadOption.PreserveChanges, ds.Tables(0))
 
        cbPlayer9.DataSource = ds.Tables(0)
        con.Close()
    End Sub
 

[11Mercenary]

Problem Solved, no need to reply :)

[BeHappy]

Hi Mr.11Mercenary,

If u solved the issue,can u please post the solution. It ll be useful for others who all are searching to solve it:)
Thank you!

[11Mercenary]

Sorry BeHappy but I solved it in a completely different way.
I changed all the appearance and the tools i was using.
Still want the code?