This documentation is archived and is not being maintained.

Add ORDER BY Clause Dialog Box - SqlDataSource 

The Add ORDER BY Clause dialog box enables you to further define a SELECT statement for a SQL data source by specifying how the results are sorted. You can specify up to three columns that will be used to sort the results.

Tasks

UI Elements

Sort by

This element specifies the first column used to sort the select results. To reset the SELECT statement to use no sorting, set this element to (None). Note that when you set this element to (None), the two Then by elements are reset as well. The default sort order is ascending. To change the sort order to descending, select the Descending option. This adds the keyword DESC to the resulting SELECT statement.

Then by

These elements specify a second and third column used to sort the select results. Note that if you set the first Then by element to (None), the second Then by element will be reset as well. The default sort order is ascending. To change the sort order to descending, select the Descending option. This adds the keyword DESC to the resulting SELECT statement

SELECT statement

This element shows the results of the SELECT statement as you set the Sort by and Then by elements.

See Also

Show: