Business Data Item Web Part in SharePoint 2010


Introduction:

Business Data Item web part in SharePoint 2010 is used to display a single row of data in a columnar format. This web part can consume a connect from the Business Data List web part which is a grid of data. The Web Part is useful when you would like to show summary data in the Grid View, but detailed data in a vertical format upon selection.

Data Source:

I have created a database in SQL which has a table with some data.

BDataISha1.gif

Sample Table:

"Sample" table has the following items.

BDataISha2.gif

External Content Type:

I have created an external content type named "New External Content Type" to integrate the external data to SharePoint using SharePoint Designer.

BDataISha3.gif

To create External Content Type using SharePoint Designer refer http://www.c-sharpcorner.com/UploadFile/anavijai/4236/.

Once you have created the external content type using SharePoint Designer , Go to Central Administration => Application Management => Manage Service Applications => Business Connectivity Service application => you could be able to see the external content type that you have created using Designer as shown in the following.

BDataISha4.gif

Set the permission for the external content type (Refer http://www.c-sharpcorner.com/UploadFile/anavijai/4252/).

Add Business Data Item web part:

  1. Go to the SharePoint site.
  2. Go to Site Actions => Edit the Page.
  3. In the ribbon interface, go to Editing Tools => Insert => Web Part.
  4. In the Categories, select Business Data => Business Data item.

    BDataISha5.gif
     
  5. Click on Add.
  6. In the web part toolbox, you can select the external content type that we have created by clicking on "Select External Content Types".

    BDataISha6.gif
     
  7. And you need to select the Item by clicking on "Select External Item(s)".

    BDataISha7.gif
     
  8. Select the item and click on Ok.

    BDataISha8.gif
     
  9. Selected item will be displayed in the web part as shown in the following.

    BDataISha9.gif

Connecting to Business Data List web part:

  1. I have a Business Data List Web Part for the same external content type which displays the following data.

    BDataISha10.gif
     
  2. Now I am going to connect the Business Data Item web part with the Business Data List web part.
  3. Edit the Business Data Item web part => Connections =>Get Item From => Business Data List.

    BDataISha11.gif
     
  4. Now the Business Data List web part looks like the following.

    BDataISha12.gif
     
  5. Based on the selection of the item in the Business Data List web part, the result will be shown in the Business Data Item web part as shown in the following

    BDataISha13.gif  
     

Up Next
    Ebook Download
    View all
    Learn
    View all