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.

NO

Before you can complete this procedure, you must set up a connection to 

TE

the database. For more information, see 

 Before you begin  on page 198

.

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:

I

In the Insert bar's Application category, click Recordset or (for 

ASP.NET) click DataSet. 

I

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.

Define a recordset 201