This part describes how to build DataWindow objects to retrieve, present, and manipulate data in your applications.
Table of Contents
- Defining DataWindow Objects
-
- About DataWindow objects
- Choosing a presentation style
- Building a DataWindow object
- Selecting a data source
- Using Quick Select
- Using SQL Select
- Using Query
- Using External
- Using Stored Procedure
- Using a Web service data source (Obsolete)
- Using the OData Service (Obsolete)
- Choosing DataWindow object-wide options
- Generating and saving a DataWindow object
- Defining queries
- What's next
- Enhancing DataWindow Objects
-
- Working in the DataWindow painter
-
- Understanding the DataWindow painter Design view
- Using the DataWindow painter toolbars
- Using the Properties view in the DataWindow painter
- Selecting controls in the DataWindow painter
- Resizing bands in the DataWindow painter Design view
- Using zoom in the DataWindow painter
- Undoing changes in the DataWindow painter
- Using the Preview view of a DataWindow object
- Saving data in an external file
- Modifying general DataWindow object properties
-
- Changing the DataWindow object style
- Setting colors in a DataWindow object
- Setting gradients and background pictures in a DataWindow object
- Setting transparency properties for a DataWindow object
- Specifying properties of a grid DataWindow object
- Specifying pointers for a DataWindow object
- Defining print specifications for a DataWindow object
- Modifying text in a DataWindow object
- Defining the tab order in a DataWindow object
- Naming controls in a DataWindow object
- Using borders in a DataWindow object
- Specifying variable-height bands in a DataWindow object
- Modifying the data source of a DataWindow object
- Storing data in a DataWindow object using the Data view
- Retrieving data
- Working with Controls in DataWindow Objects
-
- Adding controls to a DataWindow object
-
- Adding columns to a DataWindow object
- Adding text to a DataWindow object
- Adding drawing controls to a DataWindow object
- Adding a group box to a DataWindow object
- Adding pictures to a DataWindow object
- Adding computed fields to a DataWindow object
- Adding buttons to a DataWindow object
- Adding graphs to a DataWindow object
- Adding InkPicture controls to a DataWindow object
- Adding OLE controls to a DataWindow object
- Adding reports to a DataWindow object
- Adding table blob controls to a DataWindow object
- Adding tooltips to a DataWindow control
- Reorganizing controls in a DataWindow object
-
- Displaying boundaries for controls in a DataWindow object
- Using the grid and the ruler in a DataWindow object
- Deleting controls in a DataWindow object
- Moving controls in a DataWindow object
- Copying controls in a DataWindow object
- Resizing controls in a DataWindow object
- Aligning controls in a DataWindow object
- Equalizing the space between controls in a DataWindow object
- Equalizing the size of controls in a DataWindow object
- Sliding controls to remove blank space in a DataWindow object
- Positioning controls in a DataWindow object
- Rotating controls in a DataWindow object
- Controlling Updates in DataWindow objects
-
- About controlling updates
- Specifying the table to update
- Specifying the unique key columns
- Specifying an identity column
- Specifying updatable columns
- Specifying the WHERE clause for update/delete
- Specifying update when key is modified
- Using stored procedures to update the database
- Using a Web service to update the database (Obsolete)
- Displaying and Validating Data
-
- About displaying and validating data
- About display formats
- Working with display formats
- Defining display formats
- About edit styles
- Working with edit styles
- Defining edit styles
- Defining a code table
- About validation rules
- Working with validation rules
- Defining validation rules
- How to maintain extended attributes
- Filtering, Sorting, and Grouping Rows
- Highlighting Information in DataWindow Objects
- Using Nested Reports
-
- About nested reports
- Creating a report using the Composite presentation style
- Placing a nested report in another report
- Working with nested reports
-
- Adjusting nested report width and height
- Changing a nested report from one report to another
- Modifying the definition of a nested report
- Adding another nested report to a composite report
- Supplying retrieval arguments to relate a nested report to its base report
- Specifying criteria to relate a nested report to its base report
- Using options for nested reports
- Working with Graphs
- Working with Crosstabs
- Working with TreeViews
- Exporting and Importing XML Data
- Working with Rich Text
- Using OLE in a DataWindow Object
