locked
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.

    Regards,

    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,

    http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials-entity-framework-databinding-linq-entities.html

    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