Filter
Top Products
Contents
vi
DataWindow .NET
Using Quick Select....................................................................... 112
Selecting a table.................................................................... 113
Selecting columns ................................................................. 114
Specifying sorting criteria ...................................................... 115
Specifying selection criteria................................................... 115
Using SQL Select......................................................................... 121
Selecting tables and views.................................................... 122
Selecting columns ................................................................. 124
Displaying the underlying SQL statement ............................. 125
Joining tables ........................................................................ 126
Using retrieval arguments ..................................................... 129
Specifying selection, sorting, and grouping criteria............... 130
Using Query ................................................................................. 136
Using External.............................................................................. 136
Using Stored Procedure............................................................... 137
Using ADO DataSet ..................................................................... 139
Choosing DataWindow object-wide options................................. 141
Generating and saving a DataWindow object.............................. 142
About the extended attribute system tables and
DataWindow objects....................................................... 143
Saving the DataWindow object ............................................. 144
Modifying an existing DataWindow object............................. 144
Defining queries ........................................................................... 145
Previewing the query............................................................. 146
Saving the query ................................................................... 146
Modifying a query.................................................................. 147
What's next................................................................................... 147
CHAPTER 5 Enhancing DataWindow Objects................................................ 149
Working in the DataWindow painter............................................. 150
Understanding the DataWindow painter Design view ........... 152
Using the DataWindow painter toolbars................................ 154
Using the Properties view in the DataWindow painter .......... 155
Selecting controls in the DataWindow painter....................... 156
Resizing bands in the DataWindow painter Design view ...... 157
Using zoom in the DataWindow painter ................................ 157
Undoing changes in the DataWindow painter ....................... 158
Using the Preview view of a DataWindow object......................... 158
Retrieving data ...................................................................... 159
Modifying data....................................................................... 161
Viewing row information ........................................................ 162
Importing data into a DataWindow object.............................. 163
Using print preview................................................................ 163
Printing data .......................................................................... 165