Thursday, November 10, 2005

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

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
a. On the Data menu, click Filter.
b. Click Click here to add a new clause.
c. Select the Field Name that you want to filter on.
d. For the Value to compare against, click [Input Parameter].
9.Save the Web page.

5 Comments:

At 3:53 AM, Anonymous Anonymous said...

This doesn't work for me. I am modifying the default EditForm.aspx for a list, adding my own dataview wp to the top of the page, above the default editor.

I added the code as described, but get no records for my list... Is there a way to display the value of the param being passed to the filter?

 
At 12:29 PM, Anonymous Anonymous said...

This posting has more detail on passing params to data view: http://support.microsoft.com/kb/831093

Be sure to rename 'PARAM' in location to your param!..

 
At 11:15 PM, Blogger Blogueiro said...

WOW, old post but still helping... Thanks Gayan.

http://www.netzenos.com.br

 
At 2:53 AM, Anonymous Anonymous said...

Online Poker - Free start bankroll $50 - INTERNATIONAL players
no deposit poker bankroll
Regards

 
At 4:24 PM, Anonymous rinkaseoexpert said...

Phentermine is painless and hassle free, therefore it is far much better than surgical method of weight loss. Those who are planning for tummy tuck surgery should ask their doctor about Phentermine.

 

Post a Comment

<< Home