VB.Net Query Issue

Hello! I have been creating a .Net program that connects with a MySQL server to display large amounts of data in a Datagridview.  I have gotten my program to function perfectly except for my queries.  I was asked to query every field in a 38 field database and it has not been the most forgiving experience.  My main issue is that some of the database field names  have more then one word in them.  As an example, [Order Received].  I cannot create queries for these multi-word fields.  If anyone is able to help on this situation I would greatly appreciate it.

~Hydrazi
Untitled.jpg
hydraziAsked:
Who is Participating?
 
Ron MalmsteadInformation Services ManagerCommented:
Not sure, I've never really used query builder...but if I had to guess I would guess 'yes'.
I always just build my queries as a "string" and execute them in reader.
0
 
Ron MalmsteadInformation Services ManagerCommented:
Use backtick to escape the space...

SELECT `field name`
0
 
hydraziAuthor Commented:
Would I be able to do this in the query builder?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.