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.
"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 Item web part:
Connecting to Business Data List web part: