Business Data Related List Web Part in SharePoint 2010

Introduction:

Business Data Related List Web Part in SharePoint 2010 is used to display a list of related entity instances from a business application.

Data Source:

I have created a database in SQL which contains two tables.

Database Details:



EmployeeDetail Table:

"EmployeeDetail" table has the following items.

ProjectDetails Table:

"ProjectDetails" table has the following items.



Relationship between ProjectDetails and EmployeeDetail tables:

Create associated External Content Type:

Project Details External Content Type:

1. Open SharePoint Designer 2010.
2. Click on Open Site.
   
   
    
3. Enter the site URL and click on Open.
4. Go to Navigation => External Content Types => New => External Content Type.
   
   
    
5. Enter the details as shown in the following.
   
   
    
6. Click on the link "Click here to discover external data sources and define operations".
7. Click on "Add Connection".
8. In the External Data Source Type selections select "SQL Server" and click on Ok.
   
   
    
9. Enter the details as shown in the following.
   
   
    
10. Right click on ProjectDetails table and click on "Create all operations".
    
    
     
11. Click Finish.
    
    
     
12. Save the external content type.

Employee Details External Content Type:

1. Open SharePoint Designer 2010.
2. Click on Open Site.
   
   
    
3. Enter the site URL and click on Open.
4. Go to Navigation => External Content Types => New => External Content Type.
   
   
    
5. Enter the details as shown in the following.
   
   
    
6. Click on the link "Click here to discover external data sources and define operations".
7. Click on "Add Connection".
8. In the External Data Source Type selections select "SQL Server" and click on Ok.
   
   
    
9. Enter the details as shown in the following.
   
   
    
10. Right click on EmployeeDetail table and click on "Create all operations".
    
    
     
11. Click Finish.
    
    
     
12. Right click on EmployeeDetail table and click on "New Association".
    
    
     
13. Association wizard will pop up.
14. Click on browse and select "Project Details".
    
    
     
15. Click on Ok.
16. In the Field select ProjectID as shown in the following.
    
    
     
17. Click on Next and map ProjectID to Identifier as shown in the following.
    
    
     
18. Click on Finish and you could see the following operations for the External content type.
    
    
     
19. Save the external content type.

Set the permissions:

Once you have created the external content types 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.



Set the permission for the external content type (Refer http://www.c-sharpcorner.com/UploadFile/anavijai/4252/).
 
Add Business Data List web part for "Project Details" external content type:

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 List.
   
   
    
5. Click on Add.
6. In the web part toolbox, you can select the "Project Details"external content type that we have created and click on Ok.
   
   
    
7. External data will be displayed in the web part as shown in the following.
   
   
   

Add Business Data Related List 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 List.
   
   
   
    
5. Click on Add.
6. In the web part toolbox, you can select the "Employee Details"external content type that we have created and click on Ok.
   
   
    
7. Now the web part looks like the following.
   
   
   

Connect the Business Data web parts:

1. Edit the Employee Details List web part as shown in the following.
   
   
    
2. Select Connections => Get Related Item From => Project Details List.
   
   
    
3. In the Web Part tool pane, click OK.
   
   
    
4. In the Business Data List (Project Details List) Web Part, click the diagonal arrow next to a row of data, as shown in the following illustration.
   
   
    
5. Notice that the page refreshes and the Business Data Related List (Employee Details List) Web Part displays the associated data for the selected item, as shown in the following.