Databinding from mysql to gridview RRS feed

  • Question

  • User1727432505 posted

    i am databinding from my mysql database, the query is SELECT * FROM accounttable when i click test, the query brings up an error which says:

    you have an error in your SQL syntax; check the manual that corresponds to your Mysql server version for the right syntax to use near '[accounttable]' at line 1

    Sunday, February 12, 2012 8:42 AM

All replies

  • User665793701 posted

    Hi ultimate_developer,

    If you've MySQL administrator or Query browser tool,  please check the sql independently whether it work or not. The problem might on your sql not in data binding.


    Thursday, March 1, 2012 7:19 AM
  • User-460530785 posted

    just Try all small letters

    Friday, August 24, 2012 8:43 PM
  • User-578610739 posted

    Hi Friend,

    see link,


    search keyword "Posted by Keith Corlett on November 27 2011 5:47am" and read below article where step by step show how to bind.

    Tuesday, August 28, 2012 1:53 AM