Link to home
Start Free TrialLog in
Avatar of hydrazi
hydrazi

asked on

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
Avatar of Ron Malmstead
Ron Malmstead
Flag of United States of America image

Use backtick to escape the space...

SELECT `field name`
Avatar of hydrazi
hydrazi

ASKER

Would I be able to do this in the query builder?
ASKER CERTIFIED SOLUTION
Avatar of Ron Malmstead
Ron Malmstead
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial