you should make dynamic query in sql..
declare @strQuery nvarchar(max),@ColumName varchar(250),@Order varchar(10)
select @strQuery='SELECT * FROM MyTable ORDER BY '+ @ColumName +' ' + @Order
exec (@strQuery)
now if you want to sort data according to price than pass
@ColumName
='price' and
@Order
='asc' or 'Desc'
declare @strQuery nvarchar(max),@ColumName varchar(250),@Order varchar(10)
set @strQuery=' Price'
set @Order=' ASC'
select @strQuery='SELECT * FROM MyTable ORDER BY '+ @ColumName +' ' + @Order
exec (@strQuery)