Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Using the Database Results Wizard with ASP
 

Important   The following procedures will not work on a Web site located on a server running Microsoft Windows SharePoint Services.

By using the Database Results Wizard on a Web site hosted on a server running Active Server Pages (ASP) (ASP: Active Server Pages. A server-side scripting technology that is used to create dynamic interactive Web applications. An ASP file is an HTML page containing scripts that are processed by a Web server before being sent to a browser.), you can create Web pages to view and search database records.

Security  Use this feature with caution. Sensitive or confidential information could be revealed to others, such as other authors of your Web site, or site visitors on the Internet or your intranet.

ShowStart the Database Results Wizard

  • On the Insert menu, point to Database, and then click Results.

ShowSpecify ASP as the server technology and the database connection

  1. In the FrontPage has detected that your page will display best using area, clickASP, so that your pages will work correctly on a Web site located on a server running ASP.

  2. Specify the database connection you want.

ShowSpecify the record source

Do one of the following:
  • To select the table or view you want, click Record Source.
  • To create a custom query, click Custom Query, and then click Edit.

ShowSpecify the fields to be displayed on the database results page

You can do one or more of the following:
  • To exclude fields from appearing in the database results region or to change the order in which they appear, click Edit List.
  • To filter, limit, or sort the database results, to set up a search form, or to provide default values for the search, click More Options.

ShowSpecify the formatting options for the database results region

  • You can format the database results region as a table, a list, or a drop-down list.

ShowSpecify whether to display all records together or to split them into groups

You can do the following:

  • If you specified to display the records as a table or a list on the previous page of the wizard, you can specify whether to display all of the records together or to split them into groups of records with buttons to move forward or backward through the records.

  • Additionally, if you specified that you wanted to use a field as a search field in the previous page of the wizard, you can specify here that you want to add a search form to your page.

Printer-Friendly VersionPrinter-Friendly Version
© 2009 Microsoft Corporation. All rights reserved.