Filter
Top Products
CHAPTER 4 Defining DataWindow Objects
DataWindow Designer User’s Guide 139
The syntax is:
execute sp_procname;num arg1 = :arg1, arg2 = :arg2..., argn =:argn
where sp_procname is the name of the stored procedure, num is the stored
procedure group suffix, and arg1, arg2, and argn are the stored
procedure’s arguments.
The group suffix is an optional integer used in some DBMSs to group
procedures of the same name so that they can be dropped together with a
single
DROP PROCEDURE statement. For other DBMSs the number is
ignored.
4 When you have defined the entire result set, click OK.
You return to the DataWindow painter with the columns specified in the
result set placed in the DataWindow object.
For information about defining retrieval arguments for DataWindow
objects, see Chapter 5, “Enhancing DataWindow Objects.”
Using ADO DataSet
If you want to use a DataTable in an ADO.NET DataSet to build the
DataWindow, specify ADO DataSet as the data source. A File Open dialog box
displays so that you can select a typed DataSet in an XML schema definition
(XSD) file. You can then select one (and only one) of the DataTables in the
DataSet.
All the columns in the selected DataTable are included in the DataWindow. If
the DataTable is a result set from a join of multiple tables, the DataWindow will
include columns from multiple tables.
Crosstab not supported
You cannot use the Crosstab presentation style with the ADO DataSet data
source.
❖ To define the data using ADO DataSet:
1 Click ADO DataSet in the Choose Data Source dialog box in the wizard
and click Next.
A file selection dialog box displays.