Now youll 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 dont need to know SQL to create a recordset in Dreamweaver).
Youll create a recordset that selects all of the values from the COMMENTS table in the tutorial database.
NOTE |
|
Before you can complete this procedure, you must set up a connection to the database. For more information, see Before you begin. |
The Recordset dialog box or (for ASP.NET) DataSet dialog box appears.
NOTE |
|
If the dialog box you see looks more complex than the preceding dialog box, click Simple. |
The Recordset or DataSet dialog box updates with data from the database.
This step specifies that the retrieved records are listed in alphabetical order by customer last name.
The records from the database that match your recordset or DataSet selection criteria are displayed in the Test SQL Statement window. In this case, you selected all the data in the table.
The recordset appears in the Bindings panel. The Document window doesnt change.
TIP |
|
If you dont see all of the recordset fields in the Bindings panel, click Plus (+) (Windows) or click the expander arrow (Macintosh) next to Recordset (rs_Comment) to expand the recordsets structure.. |