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 ?
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?
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...
Hi jasonfp, this has sorted out the issue for me.
Cheers [:D]