MACROMEDIA DREAMWEAVER 8-GETTING STARTED WITH..., Getting Started

Page: 201 / 326

Define a recordset 201
Define a recordset
Now you’ll create a recordset to select the data you want to display. A
recordset is a set of information extracted from a database by a database
query. (In ASP.NET, a recordset is known as a DataSet.) A database query
is a way to request data from a database by using specified search criteria,
usually in a language called SQL. You then use the information extracted as
a source of content for your dynamic pages.
Dreamweaver provides an easy-to-use interface for creating simple SQL
queries (you don’t need to know SQL to create a recordset in
Dreamweaver).
You’ll create a recordset that selects all of the values from the
COMMENTS table in the tutorial database.
1.
In the Cafe Townsend document open in Dreamweaver, place the
insertion point below the Customer Comments heading.
2. Open the Recordset dialog box or (for ASP.NET) the DataSet dialog
box by doing one of the following:
■
In the Insert bar’s Application category, click Recordset or (for
ASP.NET) click DataSet.
■
Select Window > Bindings to open the Bindings panel; then click
Plus (+) and select Recordset or (for ASP.NET) DataSet.
The Recordset dialog box or (for ASP.NET) DataSet dialog box
appears.
NO
TE
Before you can complete this procedure, you must set up a connection to
the database. For more information, see
“Before you begin” on page 198 .