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.

Variables are only allowed when ordering by an expression referencing a column name.

this means using the variable in a case or if statement  (me thinks)

Remove json syntax from strings

with JavaScriptSerializer class

 JavaScriptSerializer javaScriptDeserializer = new JavaScriptSerializer();
                List<string> idList = javaScriptDeserializer.Deserialize<List<String>>(Ids);

Social skills over Methodology

here