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 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
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: