Your query must look like this:
CREATE PROCEDURE spGetDetails
@exchangetype varchar(50),
@partyname varchar(50),
@itemname varchar(50)
BEGIN
SELECT * FROM [tablename] WHERE exchangetype = @exchangetype
AND partyname=@partyname
AND itemname=@itemname
END
You need to pass the values from C# as parameters to your SQL Stored Proc.
Regards,
Eduard