How to use a URL parameter to filter a Data View Web part in FrontPage 2003

This article discusses how to pass connection information for filtering data through a URL reference in Microsoft Office FrontPage 2003.

You can use Data View Web parts with existing URL hyperlinks that pass information for processing. To do this, first update your existing Web page to use a Data View Web part, and then modify the parameter binding location to use the URL parameter string that you want to capture.

Insert a Data View

To add a Data View to your Web, page follow these steps:

1. Click the position on the page where you want your Data view to reside.
2. On the Data menu, click Insert Data View.
3. Click the data source that you want to use for your view.
4. Click Insert Data View.

Modify the parameter binding location

To modify the Data View to accept data from a URL, follow these steps:

1. Open the page in FrontPage 2003.
2. At the bottom of the edit window, click Code.
3. On the Edit menu, click Find.
4. In the Find What box, type ParameterBinding Name="filterParam", and then click Find Next.
5. Find the Location attribute in this line.
6. Replace the current Location attribute value with the following: "Postback;Connection;QueryString(Param)" Where Param is the parameter in the URL query string that you want to pass to the Data View filter.
7. At the bottom of the edit window, click Design.
8. Add a filter to the Data View. To do so, follow these steps
   1. On the Data menu, click Filter.
   2. Click Click here to add a new clause.
   3. Select the Field Name that you want to filter on.
   4. For the Value to compare against, click [Input Parameter].
9. Save the Web page.

To view the results of the filter, add the following parameter to your URL string that references this page: Param="Value" where Value is the item that you want to compare to.