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
)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.
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.
Select the Content type from the list.
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.
Document by Vairavan – firstname.lastname@example.org – + 919042710472
Navigate to the Site URL http://htc:7004/
Click on Site Action -> Site Settings
Click on Site Columns in Gallery.
Click on Create.
Create a Site column with column name StudentName and type as Single Line of Text. Click Ok.
Create Site column Age with Number as DataType.
Create a site column Place with Choice
Navigate to Site Action –>Site Settings
Click on Site Content Types in Gallery.
Click on Create.Create a site content type with name as StudentDetails and Parent Content Type from as
List Content Type and Parent Content Type as Item.
Click on Add from Existing Site column.
Select Custom Columns in the dropdown.
Add StudentName,Age,Place to Columns to add.Click on Add.
Create a Custom List as shown below.
Click on Site Action –> View All site content
Click on Create.
Select Custom List as shown.
Create a List StudentDB.
Click on Create.
Click on List settings. Click on Advanced Settings.
Change Allow Management of Content Types to Yes.
Click on Add from Existing Site content Types from Content Types Tab.
Select Custom Content Types from Dropdown as shown below.
Select Student Details and Click on Add.
Click on Ok .Now the content Type will be added to List.
Now you can see both content types.
Click on Item Content Type.
Click on Delete this Content Type.
Now you can see only one Content Type associated with the List ie. StudentDetails .
Click on New item in StudentDb List.It shows StudentDetails ContentType.
Click on New Student Details link. The New form appears as below.
Click on Modify View and Add the columns to View.
Click on Ok .Now the view looks as below.
Document by Ganesan – Ganesanva@hotmail.com – +919042710472
Given the huge demand for dot net and SharePoint applications today and the growing importance of freelancers across the city, .net and SharePoint freelancers in Chennai have engaged in providing the best available professional coaching in the software applications. The job opportunities for dot net with certification have significantly increased the number of .net freelancers in Chennai. Whether it is for professional or educational purposes, it is advisable to take a Dot net Freelance trainer in Chennai to meet the ever-changing demands of corporates and educational systems.
Hiring a Microsoft certified trainer in Chennai helps with professional coaching on Microsoft technologies such Asp.Net, C#.Net, SQL server etc. And in today’s digitalized world, the virtual presence of the trainers in substantial enough for an expert coaching on the applications. An online Dot net trainer uses the best practices of the industry to ensure dot net and SharePoint solutions meet business and educational needs of contemporary period.
A certified Dot net corporate trainer in Chennai combines the passion for technological innovation and deep platform expertise to ensure that proper training is delivered. The key focus of an online Dot net trainer in Chennai is to equip individuals leverage dot net and SharePoint technologies effectively to meet the professional and educational requirements. Young and dynamic professional and aspiring students can utilize the services of many Dot net part time consultants in Chennai to handle challenging and innovative projects. Further, given the array of opportunities in SharePoint and dot net, career as a Freelance SharePoint developer in Chennai or as an asp.net MVC consultant in Chennai holds a lot of promise for the future.
Today’s competitive market has brought dot net and SharePoint professionals to the forefront. A few years ago, a dot net or a SharePoint consultant in Chennai would have been just another consultant but today dot net and SharePoint developers have defined the career path of many individuals and professional services. Being ahead of the industry and constantly upgrading in the latest versions, dot net and SharePoint developers have been and are the preferred vendors for many corporates and students for their training and educational needs.
Along with a good demonstration of how projects are developed in real-time environment, a Microsoft certified trainer in Chennai imparts confidence and knowledge of technical skills for both freshers and working professionals and also ensures that the sessions are well structured and interactive.
With the shifting expectations of the IT industry and education, the ecosystems of dot net and SharePoint and the range of professionalism exhibited by dot net and SharePoint trainers have become more radical and created excitement and interest in learning more about the applications.