Using a variable from outside SQL Procedure in c# asp.net
===

im pretty new in sql coding and i couldent find a solution on internet, heres my code:
CREATE PROCEDURE GET_SAMEDATE
	
	(
@FileName varchar(50)
	
	(
   
  )
AS
	/* SET NOCOUNT ON */
	SELECT Hash
	FROM Beamer.PackageDetailFile A(NOLOCK)
	INNER JOIN(
	SELECT FileName,MAX(Date) MaxDate
	FROM Beamer.PackageDetailFile(NOLOCK)
	GROUP BY FileName
	)B ON B.FileName = A.FileName AND A.Date = B.MaxDate
	WHERE FileName = @FileName


what i want to do is i want to compare the FileName with the filename i obtain from a c# class