Chapter 18 Getting Started with ADO .NET 463
Table box, near the top of the dialog box. You’ll recognize the object hierarchy format
used by the table name, which is read as “the Faculty table within the Faculty2010DataSet
dataset .” If you had other tables to choose among, they would be in the list box displayed
when you click the Select Data Source Table arrow.- Type SortLastNames in the New Query Name box.
This text box assigns a name to your query, and forms the basis of toolbar buttons
added to the form. (For easy access, the default arrangement is that new queries are
assigned to toolbar buttons within the application you are building .)- Click the Query Builder button in the dialog box to open the Query Builder tool.
The Query Builder allows you to create SQL statements by typing them directly into
a large SQL statement text box or by clicking list boxes and other visual tools.- In the Last Name row representing the Last Name field in your dataset, click the cell
under Sort Type, and then click the arrow to display the Sort Type list box.
Your screen looks like this: - In the Sort Type list box, click Ascending.
You’ll sort records in the Last Name field in ascending order.