Pass Sorting Parameter To Stores Procedure

I used Datagrid to show "Title", "Location" and "Date", It works very well.


I want to sort DataGrid data, that is when user click the "Title", "Location" or "Date",


my asp.net code will through class and send "Sort" parameter to stores procedure to get the new data and bind to DataGrid.





Here is my stores procedure:





CREATE Procedure JobSearch


(


@Search varchar(150),


@Sort varchar(50)


)


AS





SELECT


JobTitle,


JobLocationCity,


JobLocationState,


PostDate





FROM


Job





WHERE


JobTitle LIKE '%' + @Search + '%'


OR


JobKeywords LIKE '%' + @Search + '%'





IF @Sort = "Title"


ORDER BY JobTitle


IF @Sort = "Location"


ORDER BY JobLocationState, JobLocationCity


IF @Sort = "PostDate"


ORDER BY PostDate DESC





When I test stores procedure in SQL Server, I got the error about "Error 156: Incorrect syntax near the keyword 'ORDER' ".





Who has experience about stores procedure, please help me to correct this error.