Export (0) Print
Expand All
Expand Minimize

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft