[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

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
0
hydrazi
Asked:
hydrazi
  • 2
1 Solution
 
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
 
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now