locked
ASP.NET TableAdapter Parameter error with MS ACCESS RRS feed

  • Question

  • User1145033923 posted

    SQL parameter not being passed for ASP>NET TableAdapter.
    The Database is a Access .mdb file.
    Error in WHERE clause near '@'.
    Unable to parse query text.

    I cannot set a parameter in the query of the TableAdapter.

    Any Idea ?

    Saturday, March 7, 2009 4:16 PM

All replies

  • User1145033923 posted
    Any Ideas ?
    Friday, March 13, 2009 5:25 PM
  • User-1199946673 posted

    Error in WHERE clause near '@'

     Don;t you think it's a good idea to show us your SQL string, in particular the WHERE clause?

    Friday, March 13, 2009 5:47 PM
  • User-1114125321 posted

    I ran into the same problem.

    All that is required is a ? to set the parameter.

    For example, 'Select * from TableName Where IDField = ?'

    Hope this helps you...

    Thursday, March 26, 2009 9:53 AM
  • User1315174242 posted

    Hi jasonfp, this has sorted out the issue for me.

     Cheers [:D]

    Monday, May 11, 2009 4:23 AM