Business Data List Web Part in SharePoint 2010


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.