MACROMEDIA DREAMWEAVER 8-GETTING STARTED WITH DREAMWEAVER Uživatelský manuál stáhnout pdf (Strana 50)

Chapter 650

Create a database recordset

Now you’ll create a recordset to display data that is stored in a database. A recordset is a subset of

information extracted from a database by a database query. (In ASP.NET,. a recordset is known as

a DataSet.) A database query consists of search criteria, which defines what’s included in the

recordset. You then use the information extracted as a source of data for your dynamic pages.

Dreamweaver MX 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 Locations table.

1 In Dreamweaver, open the Recordset or DataSet (ASP.NET) dialog box by doing one of the

following:

• In the Insert bar’s Application tab, click the Recordset or DataSet (ASP.NET) button.

• Choose Window > Bindings to open the Bindings panel, then click the Plus (+) button and

select Recordset or DataSet.

• In the Application panel group, select the Bindings panel, then click the Plus (+) button and

select Recordset or DataSet.

The Recordset or DataSet dialog box appears. The screen below shows the ColdFusion

recordset dialog box. (In ASP.NET this is the DataSet dialog box; most of the recordset options

are the same for all server models.)

2 In the Name text box, enter rsLocations.

This is the name of the recordset you are defining.

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 65 66

Žádné komentáře

MACROMEDIA DREAMWEAVER 8-GETTING STARTED WITH DREAMWEAVER Uživatelský manuál Strana 50