VB.Net Query Issue

Posted on 2012-08-16
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.

Question by:hydrazi
    LVL 25

    Expert Comment

    by:Ron M
    Use backtick to escape the space...

    SELECT `field name`

    Author Comment

    Would I be able to do this in the query builder?
    LVL 25

    Accepted Solution

    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.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now