Filter
Top Products
Using Query
136 DataWindow .NET
Using Query
When you choose Query as the data source, you select a predefined SQL
SELECT statement (a query) as specifying the data for your DataWindow
object.
❖ To define the data using Query:
1 While using any of the DataWindow wizards, click Query in the Choose
Data Source dialog box. Then click Next.
The Select Query dialog box displays.
2 Type the name of a query or use the Browse button to find the query. Then
click Next.
3 Finish interacting with the DataWindow object wizard as needed for the
presentation style you are using.
To learn how to create queries, see “Defining queries” on page 145.
Using External
If the data for the DataWindow object does not come from a database, specify
External as the data source. You then specify the data columns and their types
so DataWindow Designer can build the appropriate DataWindow object to hold
the data. These columns make up the result set. DataWindow Designer places
the columns you specified in the result set in the DataWindow object.
❖ To define the data using External:
1 Click External in the Choose Data Source dialog box in the wizard and
click Next.
The Define Result Set dialog box displays for you to specify the first
column in the result set.
2 Enter the name and type of the column.
Available datatypes are listed in the drop-down list.
3 Click Add to enter the name and type of any additional columns you want
in the result set.
4 Click Next when you have added all the columns you want.