sql server - C# SQL Top as parameter

Question

Trying to parameterize the value of TOP in my sql statement.

SELECT TOP @topparam * from table1

command.Parameters.Add("@topparam",SqlDbType.VarChar, 10).Value = somevalue.ToString();

This doesn't seem to work. Anyone have any suggestions?
Just to clarify, I don't want to use stored procedures.

Answer 1

In SQL Server 2005 and above, you can do this:

SELECT TOP (@topparam) * from table1