Firstly, your command is wrong, it will fail as you don't specify the table you want to get the data from:
SELECT * FROM Cakes
In addition, it's a good practice to always specify the columns you want rather than use
SELECT *
:
SELECT MyColumn1, MyColumn2 FROM Cakes
That way, you don't waste bandwidth fetching columns you won't use, and your code is more "future proof" against later DB changes. In your case you probably want:
SELECT `Product Name` FROM Cakes
As your column contains spaces. (It's a better idea to use non-spaced column names instead)
Instead of using checkboxes to hold your products, I'd suggest using a DataGridView - if you create a Cake class instead of using strings, you can both display more information and use the selection facilities available to the control for you user to pick the item(s) he wants. Individual checkboxes are a PITA, as you don't know at design time how many you need, and a new cake added to the DB means changing your app!
Give it a try: it's a pretty simple control to use and it makes your life a whole load eaiser!