Create External List using BCS in share point 2010
Go to Application Management -> Manage Service Applications as shown below.
Click on New ->Business Data Connectivity Service
Enter Service Application Name and Click OK.
Business Data Connectivity Service application is created as shown below,
Create New -> Secure Store Service application as shown below,
Enter the name “Secure Store Service” and Click Ok.
Secure Store service is created as shown below.
Business Connectivity service and Secure store service are the prerequisites for Creating BCS in SharePoint.
Open site in SharePoint Designer as shown below.
Open Sql Server and Create a Database StudentDB.
Create a Table EmployeeDB with below Script,
CREATE TABLE [dbo].[EmployeeDB]( [EmployeeID] [int] IDENTITY(1,1) NOT NULL, [EmployeedName] [text] NULL, [EmployeedSalary] [float] NULL, CONSTRAINT [PK_EmployeeDB] PRIMARY KEY CLUSTERED ( [EmployeeID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |
Table Design looks as below,
Go to External Content types option in SPD as shown below,
Click on External Content Type button in Top menu. The designer looks as below,
Click on the option “Click here to discover external data sources and define operations” under External Content Type Operations.
The designer looks as below,
Click on Add Connection.
Click OK.
Right Click on the Table and Select Create all operations as shown below.
Click on Next.
Click on Finish.
Save the Content Type in the Name EmployeeDB as shown below.
Open the SharePoint Site http://htc:7004/ in Browser.
Click on Site Action -> Site Content.
Click on Create.
Click on External List.
Click Create.
Select the Content type from the list.
Click Ok.
Give name as Employee Table and Click on Create.
The Output as below,
External List is created as shown below.
Now the External List allow CRUD Operation.
Recent Posts
Categories
- All
- Angularjs training in Chennai
- ASP.NET Core
- dot net training
- dot net training in chennai
- dotnet full stack developer
- Free dotnet training
- information on dotnet
- Learn Java in chennai
- Learn Python at Karaikudi
- learn python online
- learn python online from chennai
- Linq Queries in .net
- mutual funds
- MVC Training Tutorials
- PHP Training in Chennai
- pmp training online
- power apps online training
- Python Training Online
- share market
- Sharepoint framework online training
- SharePoint Freelancers in Chennai
- software testing
- spfx online training
- Stock market
- Uncategorized