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

• How to: Connect to a SQL Server Database Using the SqlDataSource Control

• How to: Connect to an Access Database Using the SqlDataSource Control

• How to: Connect to an ODBC Database Using the SqlDataSource Control

• How to: Connect to an Oracle Database Using the SqlDataSource Control

• How to: Enable Filtering for the SqlDataSource Control

• How to: Bind to Data in a Templated Control in Visual Studio

• How To: Secure Connection Strings when Using Data Source Controls

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

Reference

Configure Data Source Dialog Box - SqlDataSource

Add WHERE Clause Dialog Box - SqlDataSource

Advanced SQL Generation Options Dialog Box - SqlDataSource