Connect data in Web Parts

In this article

• Overview of web part connections

• Create web part connections

• Create or change a connection between two web parts

• Complete a web part connection in the Configure Connection dialog box

• Remove a connection between two web parts

• Common types of web part connections

Overview of web part connections

By using web part connections, you can create or enhance your web part pages. You connect web parts so that when you perform an action in one web part, it changes the contents of another web part.

For example, you can connect an Employees List View web part to the Image web part by passing data between the two web parts. Each time you select a row in the Employees List View web part that contains a column with a picture of that employee, you can see the picture displayed in the Image web part.

1. A web part connection is a way to pass data from one web part to another web part and synchronize their behavior.

2. One web part provides the data.

3. Data can be lists, rows, cells, or parameter values.

4. The other web part gets the data.

You can create the web part connection from either web part by using the connection type submenu from the Connections command on the Web Part menu. For example, if one web part's connection type submenu command says Provide Row To, the other web part's connection type submenu command says Get Row From.

Not only can you create web part connections on the same web part page, but you can also create connections between web parts on two different web part pages in the same top-level site by using a Web design program that is compatible with Microsoft Windows SharePoint Services, such as Office SharePoint Designer 2007.

Top of Page

Create web part connections

Creating a web part page with web part connections is a three-step process.

Create or change a connection between two web parts

By using menus and dialog boxes, you can connect web parts, pass data between them, and synchronize their behavior.

1. Open the web part page.

2. On the Site Actions menu , click Edit Page.

3. Decide which two web parts you want to connect. You can create or change the same connection by starting from either web part.

4. From either one of the web parts, click the Web Part menu , point to Connections, point to the type of connection that you want to create or change, such as Provide Row To or Get Sort/Filter From, and then click the name of the web part for which you want to create or change a connection.

   Key to commands on the Connections submenu

   Command on the Connections submenu	Description
   Provide Row To	You can connect the List View web part to another web part by passing a selected row of data to the other web part. Depending on how the other web part was created and gets the data, the other web part might display the row data or use the row data as a filter or parameter value. In standard view, a Select Item column containing option buttons is automatically added when you connect the List View web part, so that you can indicate which row to pass to the other web part. You can select only one row at a time in standard view. Some columns, such as the Edit column, are not available for use in a web part connection. In datasheet view, you can select multiple rows, but only one row is passed to the other web part. If multiple rows are selected, the row containing the active cell is passed to the other web part, and all other rows are ignored. You cannot provide data in the Total row or New row to the other web part. With this type of connection, you can have more than one web part connected to the List View web part.
   Provide Data To	You can connect the List View web part to another web part that works with list data. In this case, the List View web part is the data source for the other web part. In standard and datasheet view, only the data in the view is provided to the other web part. With this type of connection, you can have more than one web part connected to the List View web part.
   Get Sort/Filter From	In standard and datasheet view, you can connect the List View web part to another web part that can provide the following information to it: 1. One or more column name and value pairs of data that filter data in the List View web part. 2. A column of data to sort data by either ascending or descending order in the List View web part. With this type of connection, only one other web part can be connected to the List View web part.

   Note: The Web Part menu may not be enabled or visible on your web part page for several reasons, including that the web part or the zone does not support connections, you are using a browser that is not compatible with Windows SharePoint Services, or connections are disabled on your site.

5. For some web part connections, you might need to select additional information in the Configure Connection dialog box. For example, you might need to select the connection type that you want to use or a column that you want to filter. Also, depending on how one or both of the web parts were created, you may see additional dialog boxes that are unique to the web part connection. For more information, see the Help information, if any, for the custom web part.

   Tip: You can hide a web part if you want to use it to provide data to another web part through a web part connection, but you don't want to display the web part.

   Notes: 

   • The connection type submenu can vary from web part page to web part page and from web part to web part for several reasons, including differences among the property settings for the web part page, web part, or web part zone, the type or compatibility of web parts on the page, and whether the web parts have compatible connection types.

   • Only web parts that can be connected appear on the available Web Parts submenu. Some web parts on the web part page may not be designed to make connections, some web parts may not support connections to the current web part, or certain connection limits may currently be exceeded.

Top of Page

Complete a web part connection in the Configure Connection dialog box

You use the Configure Connection dialog box to match columns between the web part that gets the data and the web part that provides the data.

In the Column list box, select a column from the web part that gets the data, the web part that provides the data, or both.

The following are common examples:

• Matching a row of data in one web part to a cell or field of data in another web part    

  The web part that you are connecting from is a Contacts List View web part. One of the columns in the list view is a column that contains a hyperlink called Photo, which contains a URL to a picture of the contact. You make a connection to the Image web part, which can display only a URL that contains a picture. You need to choose the Photo column from the Contacts web part to provide the correct match to the Image web part.

• Matching a row of data in one web part to a column of data in another web part so that you can filter it    

  The web part that you are connecting from is a List View web part that contains order data. One of the columns in the list view is a column that contains a line item called OrdersDetailsID. You make a connection to another List View web part that has several columns that contains order details, one of which is a matching column called OrdersDetailsID. To connect the two web parts so that when you select the order in one web part, it displays each line item for that order in the other web part, you must match the OrdersDetailsID columns in each web part.

  Note: The column names do not have to be the same, but the underlying data must match or have the same value.

Top of Page

Remove a connection between two web parts

1. Open the web part page.

2. On the Site Actions menu , click Edit Page.

3. From either one of the web parts from which you want to remove the connection, click the Web Part menu , point to Connections, point to the type of connection that you want to remove — for example, Provide Row To or Get Sort/Filter From — and then click the name of the web part from which you want to remove a connection.

   Note: A check mark appears on the connections submenu for each selection that has a connection enabled. If you do not see a check mark, no connection is enabled.

4. In the Configure Connection dialog box, click Remove Connection.

5. When you are prompted to confirm that you want to remove the connection between web parts, click OK.

Top of Page

Common types of web part connections

There are many ways to combine and connect web parts on a web part page. You can create several of these web part connections on your web part page. The following scenarios describe common types of data connections between web parts.

Master and details

You have a master list of data and you need to display detailed information related to this master list.

1. An Employee Basics Web Part contains basic, frequently accessed employee data, such as ID, name, and job title.

2. To look up employee details, you select a row.

3. The row is passed to the other Web Part.

4. In the Employee Details Web Part, all the employee details are displayed in a form.

In a List View web part, you can even sort and filter a large list to help find the employee before you select the row. If the detail data is extensive, you can even display the Employee Details web part on another web part page.

Summary and details

You have a summary list of data and you need to display the detailed information that produces the summary data.

1. A Year-to-Date Pay Stub Web Part contains your compensation information.

2. You select the summary information about your accumulated vacation time and sick days.

3. The summary information is passed to the other Web Part.

4. In the Pay Stub Details Web Part that displays weekly data, you verify the data that you see recorded.

Parent and child

You display a list of data (the parent), and for each row there is one or more related rows (the children) that you want to display in another list.

1. An Orders Web Part provides a list of the most recent customer orders.

2. You click the row that contains the order that you want to examine.

3. The row is passed to the other Web Part.

4. In the Order Details Web Part, all the line items for that order are displayed.

Search and filter

You want to enter data, such as search or filter criteria, in one web part to display the results in another web part.

1. In the Book Search Web Part, you enter the book information, such as title, author, and subject, to try to find the book or set of books.

2. You click SUBMIT.

3. The search criteria are passed to the other Web Part.

4. The Book List Web Part displays one or more books that match your search criteria.

Calculations

Although you can often calculate data inside a web part, sometimes you may want to combine two web parts to make your calculations more flexible.

1. You enter mortgage numbers into a Mortgage Numbers Web Part.

2. You click GO.

3. The mortgage numbers are passed to the other Web Part.

4. The Mortgage Calculator Web Part computes the mortgage and displays the monthly payment schedule.

Alternate data views

Viewing your data in several different ways can help you to understand implications, trends, and relationships. You can pass lists, rows, and cells (or fields and parameters) from one web part and display the data in an alternate view.

For example, for an alternate view of a list, you may want to display all company employees in a hierarchy chart.

1. The Employees Web Part displays the employee ID, employee name, job title, and manager ID of everyone who works for your company.

2. Because you use all the data, no selection is required.

3. All the data is passed to another Web Part.

4. The Organization Chart Web Part displays the working relationships between employees and can display alternate views of this hierarchy.

For an alternative view of a row, you may want to view a row of demographic data in a chart, such as a pie chart or bar graph.

1. A Population Statistics Web Part displays demographic data such as age, income, and heritage.

2. You select a row of demographic data.

3. You pass the data to another Web Part.

4. The Chart Web Part displays the row of data in a pie chart and alternatively a bar graph.

For an alternate view of a cell, you may want to track the overall progress of a fund-raising drive.

1. In a Fund-Raising Web Part, each member of a group enters how much money he or she raised.

2. The current total is displayed in a total field.

3. The total field is passed to the other Web Part.

4. You check your group's overall progress in the Charity Goal Web Part.

Data enhancement

You want to augment basic data about people and places to make it more interesting, appealing, and useful.

1. A Contacts Web Part displays information that you must have to keep track of business associates, such as name, address, and perhaps a photo.

2. You select a contact.

3. A row of data is passed to the other Web Part.

4. You see a photo of the contact displayed in the Image Web Part and then locate the contact's business address in a Map Web Part.

Top of Page