StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODynamic order by in SqlDataSource by a dropdownlist and grid view
text
Body
copied!<p>I have a grid view that connect to the DataSqlSource. I want to sort my queries dynamically by a dropdownlist. for example by date,name,family etc. I also join some tables in my queries. I use this code in my DataSqlSource:</p> <pre><code> SELECT AddTitle.Title, SubmitManuscript.Status, AddArticleType.Type, AddArticleType.UserName, AddArticleType.ArticleType, SubmitManuscript.date, SubmitManuscript.ArticleNum, AddArticleType.ArticleID, CONVERT (VARCHAR(10), SubmitManuscript.date, 103) AS date1, OtherWritter.ArticleID AS Expr1, OtherWritter.name, OtherWritter.family, AddArticleType.CheckFinish FROM AddArticleType INNER JOIN AddTitle ON AddArticleType.ArticleID = AddTitle.ArticleID INNER JOIN SubmitManuscript ON AddArticleType.ArticleID = SubmitManuscript.ArticleID INNER JOIN OtherWritter ON AddTitle.ArticleID = OtherWritter.ArticleID WHERE (AddArticleType.ArticleID IN (SELECT ArticleID FROM AddUpload_4 AS AddUpload_4_1 WHERE (AddArticleType.CheckFinish = '0'))) AND (AddArticleType.Type = @Type) AND (SubmitManuscript.Status = 'Accept') AND (OtherWritter.MainAuthor = 'Yes') ORDER BY '[' + @SortOrder + ']' DESC </code></pre> <p>but it doesn't work for me and no sorting happen!</p> <p>And I also try this code, this time it gave me an error: here is the code:</p> <pre><code>SELECT ... FROM ... ORDER BY CASE WHEN @order=Country THEN Country END DESC, CASE WHEN @order= City THEN City END ASC, CASE WHEN @order= name THEN name END ASC </code></pre> <p>Can any body help me?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload