ASP.NET TableAdapter Parameter error with MS ACCESS

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 ?

Answer 1

User1145033923 posted
Any Ideas ?

Answer 2

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?

Answer 3

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

Answer 4

User1315174242 posted

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

 Cheers [:D]