ASP.NET How to remove double quotation from parameterized SQL query?

Question

I seems not working because double quotations are also inserted when i use parameterized SQL query. How can i remove the double quotations?

cmd.Parameters.AddWithValue("@SORT", (rdbAscending.Checked) ? "ASC" : "DESC");

Answer 1

Take a look at this post to see how you can use parameters in the ORDER BY clause.