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

 
 
Microsoft Office FrontPage
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
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
About creating data-driven Web sites
 

Important  To create a data-driven Web site in Microsoft Office FrontPage 2003, you must be using Microsoft Windows SharePoint Services, which provides the component-based platform required for FrontPage data-driven functionality. To use Windows SharePoint Services, the following technologies are required on your Web server:

  • Microsoft Windows Server 2003, Standard Edition, Enterprise Edition, Datacenter Edition, or Web Edition
  • Microsoft Internet Information Services (IIS) 6.0 in IIS 6.0 worker process isolation mode
  • ASP.NET

What is a data-driven Web site?

The Internet is full of Web sites that require the Web site creators to edit the HTML every time a content change needs to be made. With so much to do to make changes, it is no wonder there are so many static Web sites on the Internet!

A data-driven Web site, on the other hand, changes automatically because it draws its content from external dynamic data sources. The data sources that FrontPage 2003 supports include:

A well-architected, data-driven Web site is much easier to maintain than a static Web site because most content changes require no change to the HTML behind the Web site. Instead, changes are made to the data source that drives the Web site, and the Web site automatically adjusts to reflect those changes. With a data-driven Web site, you connect to and present live data from a variety of data sources. Web site visitors upload the data from your Web site by using a Web browser.

When you create a data-driven Web site in FrontPage, you select a data source from the data source catalog, and then you add a Data View to your Web site that extracts data from the data source. When you add a Data View to your Web page, you're actually inserting something called a Data View Web Part.

Case scenario: Using Data View Web Parts

Lisa Jacobson is an intranet Web designer for the Animal Health Division at the Contoso Pharmaceuticals company. Lisa is creating a Web site for the purchasing department in this division to help improve the accuracy of information on their site about the availability of medical supplies.

The purchasing staff records the dispensing of medical supplies in a Microsoft SQL host-based database and this helps them to be aware of when to order more.

To make the information easier to access, Lisa will add a Data View Web Part that will connect to the SQL database (data source). When connected, and when queried by site visitors, the Web Part will extract the most up-to-date and accurate inventory data from the data source. To improve awareness about items low in inventory, Lisa uses Conditional Formatting in the Data View to highlight medical supplies that are fewer than 10 in stock.

ShowMore about Data Views

By using FrontPage, you can add Data Views to your Web site that display data by using Extensible Stylesheet Language Transformations (XSLTs) (XSL Transformation (XSLT): A file that is used to transform XML documents into other types of documents, such as HTML or XML. It is designed for use as part of XSL.).

You can customize Data Views to create custom displays of your data in WYSIWYG (WYSIWYG: Acronym for What You See Is What You Get. Allows you to view a document as it will appear in the final product and to directly edit the text, graphics, and other elements within that view.) format by using the Formatting toolbar. You can also perform more advanced customizations by using the Data View Details task pane:

  • Style   Choose a formatting style from a gallery of predesigned list view styles. You can also add a toolbar for site visitors to perform custom filtering on the list.
  • Filter   Specify criteria to display a subset of the data in the Data View.
  • Sort & group   Display items in a particular order and optionally group them on a Web page beneath collapsible headings.
  • Conditional Formatting   Set conditions for the data in your Data View.

Microsoft Windows SharePoint Services, which is built on the Microsoft .NET Framework, provides the component-based platform required for FrontPage data-driven functionality.

ShowAbout Web Part connections

When you add Web Parts to your page by using FrontPage, you have more control over how they appear than you would by working with them on your SharePoint site. You can even create connections between Web Parts so that when you perform an action in one Web Part, it changes the contents of another Web Part.

Connecting sets of data from different data sources usually requires advanced programming skills, but by connecting Web Parts, you can pass data between them and synchronize their behavior. For example, you can connect a List View Web Part, which contains a column with a hyperlink data type, to an Image Web Part, which contains a picture of an employee. Each time you select a row in the List View Web Part, you can see the picture of the employee displayed in the Image Web Part.

Although you can establish a Web Part connection by using the Web browser, by using FrontPage, you can extend the functionality of Web Part connections. For example, you can use the Form Web Part to filter the data in another Web Part, or you can establish connections between Web Parts on two Web Part Pages in the same top-level Web site.

ShowAbout the Form Web Part

Form Web Parts are a case-sensitive, filtering mechanism, and they work with Microsoft Windows SharePoint Services Web sites only.

By using the Form Web part in FrontPage, you can extend the functionality of Web Part connections by enabling site visitors to enter data through a familiar form-like interface, which passes data into a Web Part connection. Similar to a search box, site visitors can, for example, filter on data contained in the List View Web Part by using the Form Web Part.

By using the Form Web Part option, you cannot build a form that lets you collect data and send it to a database or e-mail address. Instead, to collect data from your customers, on the Insert menu, point to Forms, and then click List Form or Form.

If you are running a Web site based on Windows SharePoint Services, you can use the following forms:

  • List Forms, which are used to input data to a SharePoint list.
  • Forms, which are used to collect data to a standalone text or XML file.
  • Form Web Parts, which are used to filter for information on your SharePoint site, and work by using the Web Part Connections technology.

Important  If you are running a Web site that is not based on Windows SharePoint Services, such as a disk-based Web or by using the FrontPage Server Extensions, on the Insert menu, point to Forms, and then click Forms. The other forms options may be unavailable because you are not running a SharePoint Web site.