How to dynamically change the name of the column in the sqlstatement to use to retrieve data using a combobox

advertisements

I want to dynamically change the name of the column in my sqlstatement every time I select an item name similar of the columns on the cmbcategory comboBox. Then use it to get its data to be transferred to the cmbparts comboBox. Is it possible?

This is my sample code:

    Public Sub cmbpartfill()

        sqlstatement = "select '" & cmbcategory.Text & "' from tblparts"
        Connect()
        command = New MySqlCommand(sqlstatement, connection)
        reader = command.ExecuteReader
        While reader.Read
            cmbpart.Items.Clear()
            cmbpart.Items.Add(reader.Item(0).ToString)
        End While
        Disconnect() 

    End Sub

I would appreciate any help. Thanks.


This will work I think...............

sqlstatement = "select " & cmbcategory.Text & " from tblparts"

Edited: Just try i am not sure............

sqlstatement = "select [" & cmbcategory.Text & "] from tblparts"