About Connecting a List View Web Part

The List View Web Part has two different tabular views: Standard view, which is available to any user, and Datasheet view, which is an Office Excel-like spreadsheet that uses the Microsoft Office List Datasheet Component and requires Microsoft Office Professional Edition 2003 installed on your client computer.

Using either Standard or Datasheet view, you can connect a List View Web Part to another Web Part, provide data to it, and change the way data is displayed in the other Web Part, including another List View Web Part. The following connection type commands on the Connections submenu of the Web Part menu are available:

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, it might display the row data or use it 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 you can indicate which row to pass to the other Web Part. You can only select 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.

You can have more than one Web Part connected with this type of connection to the List View Web Part.

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.

You can have more than one Web Part connected with this type of connection to the List View Web Part.

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:

One or more column name and value pairs of data that filter data in the List View Web Part.
A column of data to sort data by either ascending or descending order in the List View Web Part.

Only one other Web Part can be connected with this type of connection to the List View Web Part.

Although you can display all list types in a List View Web Part, only certain list types are supported when making a Web Part connection. In general, list types that display data in tabular format, such as Contacts, are supported. Lists that display data in a non-tabular format, such as Folder view, are not supported.

Supported list types in a Web Part connection

Supported list types include the following:

Announcements
Contacts
Events
Links
Tasks
Custom Lists
Lists that contain data imported from a spreadsheet
Document Libraries
Form Libraries

Unsupported list types in a Web Part connection

Unsupported list types include the following:

Calendar view of an Events list
Discussion Boards
Issues
Surveys
Picture Libraries
Site and List Template Catalogs
Web Part Galleries
Data Sources

Although you can display all list column types in a List View Web Part, only certain list column types are supported when making a Web Part connection.

Supported list column types in a List View Web Part connection

Supported list column types include the following:

Single line of text
Choice
Number
Currency
Date and Time
Hyperlink or Picture (for matching columns)
Lookup
Yes/No
Calculated

Unsupported list column types in a Web Part connection

Unsupported list column types include the following:

Hyperlink or Picture (for filtering)
Mutiple Lines of Text
Edit