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"