Business Data List Web Part in SharePoint 2010

Anavijai
Posted by in SharePoint category on for Intermediate level | Points: 250 | Views : 10463 red flag

Business Data List Web Part in SharePoint 2010 is used to display the Line of Business data within a grid view format. The Business Data List web part is the most commonly used web part for displaying LOB data.

Introduction

Business Data List Web Part in SharePoint 2010 is used to display the Line of Business data within a grid view format. The Business Data List web part is the most commonly used web part for displaying LOB data.

Data Source:

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

Sample Table:

"Sample" table has the following items.

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.


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.


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

Add Business Data 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 external content type that we have created and click on Ok.

External data will be displayed in the web part as shown in the following.



In the next article, we shall learn how to Create a Content Source Scope Rule in SharePoint 2010 using PowerShell.

Hope this article was useful, keep reading my forthcoming article of this series.

Thanks

Page copy protected against web site content infringement by Copyscape

About the Author

Anavijai
Full Name: Vijai Anand R
Member Level: Starter
Member Status: Member
Member Since: 5/22/2011 5:12:38 AM
Country: India
Vijai Anand.R
http://www.dotnetfunda.com
SharePoint Developer

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)