Right, you should use the =@studentno for your query, so it will be something like


SELECT StudentName FROM StudentTable
WHERE StudentNo = @StudentNo


Where StudentNo is the name of the...