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

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.