Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2008
Visual Studio
Visual Web Developer
Visual Web Developer User Interface Elements
Accessibility Validation Dialog Box
Accessibility, Web Site Property Pages Dialog Box
Add Field Dialog Box
Add New Column, Add Fields Dialog Box
Add ORDER BY Clause Dialog Box - SqlDataSource
Add Web Reference Dialog Box
Add WHERE Clause Dialog Box - SqlDataSource
Advanced SQL Generation Options Dialog Box - SqlDataSource
Advanced Options - LinqDataSource
ASP Debugging Configuration Error Dialog Box
Auto Format Dialog Box
Auto Format Dialog Box (Calendar Control)
Auto Format Dialog Box (Design view)
Background, Style Builder Dialog Box
Bookmark Dialog Box
Borders and Shading Dialog Box
Build Style Dialog Box
Build, Web Site Property Pages Dialog Box
Bullets and Numbering Dialog Box
Cell Properties Dialog Box
Check Accessibility Dialog Box
Choose Location Dialog Box
Color Dialog Box
Color Picker Dialog Box
Command and Parameter Editor Dialog Box
Configure Data Source Dialog Box - AccessDataSource
Configure Data Source Dialog Box - LinqDataSource
Configure Data Source Dialog Box - ObjectDataSource
Configure Data Source Dialog Box - SqlDataSource
Configure Data Source Dialog Box - XmlDataSource
Configure ListView Dialog Box
Configure Order By Expression - LinqDataSource
Configure Where Expression - LinqDataSource
Create New FrontPage Web Dialog Box
CSS Editor
CSS Specific, CSS, Text Editor, Options Dialog Box
Data Source Configuration Wizard (Visual Web Developer)
DataBindings Dialog Box
DataBindings Editor Dialog Box (TreeView or Menu Control)
DataGrid Properties Dialog Box
DataList Properties Dialog Box
Debugging Not Enabled Dialog Box
Display, HTML Designer, Options Dialog Box
Double-Click HTML Element
Edges, Style Builder Dialog Box
Edit Columns Dialog Box (Design view)
Expressions Dialog Box
Expression Editor - LinqDataSource
Fields Dialog Box
Fields Dialog Box - DataPagerField
File System Tab, Choose Location/Open Web Site Dialog Box
Font Dialog Box
Font, Style Builder Dialog Box
Format, Convert to Hyperlink Dialog Box
Format, CSS, Text Editor, Options Dialog Box
Format, HTML, Text Editor, Options Dialog Box
Formatting, JScript, Options Dialog Box
FrontPage Components Dialog Box
FTP Site Tab, Choose Location/Open Web Site Dialog Box
FTP Log On Dialog Box
General Tab, Options Dialog Box (Visual Web Developer)
General, CSS, Text Editor, Options Dialog Box
General, HTML Designer, Options Dialog Box
General, HTML, Text Editor, Options Dialog Box
General, JScript, Options Dialog Box
HotSpot Collection Editor
HTML Designer
HTML Document Properties, Properties Window
Item Editor Dialog Box (Menu Control)
Layout, Style Builder Dialog Box
Lists, Style Builder Dialog Box
Local IIS Tab, Choose Location/Open Web Site Dialog Box
Login failed for user <user>
Miscellaneous, HTML, Text Editor, Options Dialog Box
Miscellaneous, JScript, Options Dialog Box
MSBuild Support, Web Site Property Pages Dialog Box
New Style Dialog Box, Background
New Style Dialog Box, Block
New Style Dialog Box, Border
New Style Dialog Box, Box
New Style Dialog Box, Font
New Style Dialog Box, Layout
New Style Dialog Box, List
New Style Dialog Box, Position
New Style Dialog Box, Table
New Virtual Directory Dialog Box
New Web Site Dialog Box
Open Web Site in Solution Dialog Box
Paragraph Dialog Box
Parameter Collection Editor Dialog Box
Parameter Values Editor Dialog Box
Personal Web Site Starter Kit
Position Dialog Box
Position, Style Builder Dialog Box
Publish Web Site Dialog Box
References, Web Site Property Pages Dialog Box
Remote Sites Tab, Choose Location/Open Web Site Dialog Box
Resize Column Dialog Box and Resize Row Dialog Box
Select a Configuration to Upgrade Dialog Box
Select Project Item Dialog Box
Source Control Tab, Choose Location/Open Web Site Dialog Box
Standard Tab, Toolbox
Start Options, Web Site Property Pages Dialog Box
Styles, Add Style Rule Dialog Box
Table, Insert Rows or Columns Dialog Box
Table, Insert Table Dialog Box
Table, Modify, Split Cells Dialog Box
Tabs, CSS, Text Editor, Options Dialog Box
Tabs, HTML, Text Editor, Options Dialog Box
Tabs, JScript, Options Dialog Box
Tag Specific Options
Text, Style Builder Dialog Box
The Project Location is Not Trusted Dialog Box
TreeView Line Image Generator Dialog Box
TreeView Node Editor Dialog Box
Validation, HTML, Text Editor, Options Dialog Box
Web Forms Designer
Web Site Already Exists Dialog Box
Web Site URL Required Dialog Box
Expand Minimize
This topic has not yet been rated - Rate this topic

Add ORDER BY Clause Dialog Box - SqlDataSource

Visual Studio 2008

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.