Stored Procedure With Order By Variable

I am trying to create a stored procedure that is sent a column name and orders by the column name.   conn = New SqlConnection(SQLserver)SQL = New SqlCommand("SearchECN", conn)

SQL.CommandType = CommandType.StoredProcedure

SQL.Parameters.Add("@Search", SqlDbType.Variant)SQL.Parameters.Add("@Sort", SqlDbType.Variant)

SQL.Parameters(0).Value = Search.Text

SQL.Parameters(1).Value = "ECN.ECN"

SQL.Connection.Open()

GVECN.DataSource = SQL.ExecuteReader()

GVECN.DataBind()

SQL.Connection.Close()

SQL.Connection.Dispose()

 

Stored Procedure

@Search NVARCHAR(MAX),

@Sort NVARCHAR(MAX)

SELECT ECN.ECN, ECN.A, ECN.B FROM ECN WHERE ECN.ECN LIKE @Search OR ECN.A LIKE @Search ORDER BY @Sort

I get the following error

Msg 1008, Level 16, State 1, Line 10

The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

 

Any Ideas