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.