We help IT Professionals succeed at work.

VB.Net Query Issue

hydrazi
hydrazi asked
on
Medium Priority
603 Views
Last Modified: 2012-08-20
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
Comment
Watch Question

Ron MalmsteadInformation Services Manager
CERTIFIED EXPERT

Commented:
Use backtick to escape the space...

SELECT `field name`

Author

Commented:
Would I be able to do this in the query builder?
Information Services Manager
CERTIFIED EXPERT
Commented:
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.