Macromedia dreamweaver 8-using dreamweaver User Manual
Building pages to update a record (ASP.NET)
919
Retrieving the record to update (ASP.NET)
After the search page passes a URL parameter to the update page, the update page must read
the parameter, retrieve the record from the database table, and store it temporarily in a
DataSet.
the parameter, retrieve the record from the database table, and store it temporarily in a
DataSet.
To retrieve the record to update:
1.
Create a new ASP.NET page in Dreamweaver and save it.
The page will become your update page.
2.
In the Bindings panel (Window > Bindings), click the Plus (+) button and select
DataSet (Query).
DataSet (Query).
If the advanced dialog box appears, click the Simple button to open the simple dialog box.
3.
Name the DataSet, and then select a connection and database table containing the data you
want users to update.
want users to update.
4.
Click the Selected option and select a key column (usually the record ID column) and the
columns containing the data to be updated.
columns containing the data to be updated.
5.
Configure the Filter area so that the value of your key column equals the value of the
corresponding URL parameter passed by the search page.
corresponding URL parameter passed by the search page.