VB.NET: Populating ComboBox Using MySQL Query

Question

I am trying to populate a Combobox from a MySQL database; but I don't get anything. Below is the code.

Table: Class

Columns: Code, State

sqlstr = "SELECT * FROM Class WHERE State= Not Started"
DBCmd = New MySql.Data.MySqlClient.MySqlCommand(sqlstr, DBConn)
DBDR = DBCmd.ExecuteReader
While (DBDR.Read())
CB_Class.Items.Add(DBDR("Code"))
End While
DBCmd.Dispose()
DBDR.Close()

I believe the result is wrong, because there are at least 2 records with their state values set as "Not Started". What is wrong? Is there anything wrong with the way I've written "State= Not Started" ?

The program works fine until it reaches DBDR = DBCmd.ExecuteReader. It doesn't execute any further. — Parsa Dorbeigi
– Parsa Dorbeigi, Commented Apr 4, 2013 at 23:20

Steve · Accepted Answer · 2013-04-04 23:22:39Z

1

The command text doesn't seems correct. It lacks the single quote around the string to search

sqlstr = "SELECT * FROM Class WHERE State='Not Started'"
                                          ^           ^

If State is a string field then every search over it should be enclosed in single quotes.
Beware of the potential problems when the string to search contains a single quote.

In this simple case you could use directly the string constant, but if you render your search dynamic with user input then you should use parametrized queries.

answered Apr 4, 2013 at 23:22

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VB.NET: Populating ComboBox Using MySQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related