How to: Create a Business Data List Web Part

  • Article

The Business Data List Web Part displays a list of entity instances from a business application registered in the Business Data Catalog. For example, you can use a Business Data List Web Part to display the customers or products from the AdventureWorks2000 database. This procedure shows how you can add a Business Data List Web Part to display a list of products from the AdventureWorks2000 database.

Note

This procedure does not involve writing code. Before using this procedure, however, register the AdventureWorks SQL Server 2000 Sample in the Business Data Catalog.

To add a Business Data List Web Part

  1. Open the Microsoft Office SharePoint Server 2007 page where you want to add the Web Part.

  2. On the Site Actions menu, click Edit Page. The Site Actions menu is located on the upper right side of the page, below the Advanced Search link.

  3. Click Add a Web Part in the zone in which you want to display the Web Part.

  4. In the Add Web Parts - Web Page dialog box, select Business Data List, and then click Add.

  5. In the Business Data List Web Part that is added, click Open the tool pane. (If you are prompted to click OK to navigate away from the current page, do so. Otherwise, proceed to the next step.)

  6. In the tool pane, click Browse, and then choose Product (AdventureWorksSample). Click OK.

  7. Expand the Appearance section.

  8. For Title, replace Business Data List with Products from AdventureWorks, and then click OK.

  9. On the right side of the newly added Web Part, click Edit View. Do the following:

    • In Items to Retrieve, select Retrieve all items.

    • In Columns, select ID and List Price.

  10. Click OK.

The new Business Data List Web Part now displays products from the AdventureWorks 2000 SQL Server database.