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.