get error when use @ in tableadapter

Question

I write code in Query Builder When i add Table Adapter in Dataset Design in MVS C# 2015 I create Dataset to make report   I use Data Microsoft Access 2010.When i watch movie, they use SQL Server   Select * from Table2 Where manv = @manv   But i get Error when click Finish Button   Error : "Error near Where Clause near '@'  "Unable to parse query text"     I want to pass paramater in report, i see video on YouTube very clear, but i only get error when design paramater   Please help me

Sachin Singh · Answer

use '?' instead of '@' and let me know it worked or not?

Kiran Mohanty · Answer

I guess you have written below code .  string query = " Select * from Table2 Where manv = @manv " ;   If so, you will have to write it as below. I am assuming you have set your query value in "manv" variable.  string query = " Select * from Table2 Where manv = " + manv ;

bryann ali · Answer

I encountered this issue but I was able to solve this one by adding a new parameter by hand(not by SQL/Query Builder) from the “Properties Window”. I added a parameter from the “Parameters” property of the “Query” of the TableAdapter.
The SQL remains without “WHERE” clause but when calling from anywhere(code or preview data) it asks for this parameter. Hope this can help you

Nam Lehoai · Answer

i am using C#, not Sql Server. I am making a report by send paramater In C# You dont understand my question

Bhuvanesh Mohankumar · Answer

How you are assigning value to parameter @manv, is value fetching properly if you "Select @manv" Can you share your code here?

Nam Lehoai · Answer

dear sir, i am using Visual Studio C# to connect MS Access. I want to create report.Iget error at design TableAdapter at DataSet Enviroment IT is OK when using "Select * from Table2" Only get error when type "Select * from Table2 where manv = @manv"   I should show me the way in VS C#

Bhuvanesh Mohankumar · Answer

Firstcheck the following, Make a select @manv to find the value is available in that parameter. Itis always advisable to add the parameter values and execute in stored procedure, which is good way. Sample: create procedure getSalesperson
@sp varchar(25)
as
select SalesPerson, Mon, amount
from SalesData
where SalesPerson = @sp;
Go Execution: declare @sp varchar(25)
set @sp = 'Jack'
exec getSalesperson @sp
Mark as answer, if helpful.