Question

Define in the details about the creatation of recordset

Answer 1

Define a recordset

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.

NOTE

Before you can complete this procedure, you must set up a connection to the database. For more information, see Before you begin.

In the Cafe Townsend document open in Dreamweaver, place the insertion point below the Customer Comments heading.

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.



NOTE

If the dialog box you see looks more complex than the preceding dialog box, click Simple.

In the Name text box, enter rs_

In the Data Source pop-up menu (ColdFusion) or Connection pop-up menu (other server page types), select connTownsend.

The Recordset or DataSet dialog box updates with data from the database.