Business connectivity services - External list in SharePoint 2010

By -

Create External list in SharePoint 2010 :

       In SharePoint you can create a external list(connect with SQL Server Db & table)Here i will explain how to do that.Before that you need to have or create one database and one table(which we need to connect as external list).If you already have the do the following steps,otherwise create one Database and one table and do the following.

Steps to Create External List :

1.Open SharePoint designer & give your site url click open.

2.Click External Content Types(which was in left side) -> click External content Type(Placed in Top Ribbon)


3.Give name for External content Type and click->Click here to discover data source and define operations
shown in below

4.Click Add New Connection->select SQL Server click OK
5.Give  SQL Server name and Your Data Base name then click OK
6.If you are facing any error(like Below image) while clicking OK, You need to add users permissions for your database in your SQL server For that
Open SQL Server->Security->Logins->Right Click on users whoever you want to add permissions->
Properties->User Mapping->Find your Db name and Click the Checkbox of your Database name->
Below Click check box of db_owner click OK
(Like this you need to add every user you want to access)
7.Now click OK,& that error will not come.Your Database will be added here.
Now expand Db name and tables ->Right click on your Table Name->
Create All Operations->Next->Here your need to set on primary key(Which should be unique)->
click Finish

8.Save this work(Which was placed in Top Left Corner of designer)
That's all you have almost done!

9.create a External list from SharePoint site or Designer.
In designer click Lists And Libraries->click External list on top Ribbon->
Select your Db name->click OK->give list Name click OK
.

10.Open your site and there you can see your external list.And If you edit this list here 
it will automatically updated in SQL server also.

Comments

Post a Comment

Popular posts from this blog

Upload Single/Multiple file by using the REST API and jQuery SharePoint 2013

By -
Image
Upload  Single/Multiple  file by using the REST API and jQuery SharePoint 2013 Here you can find how to upload single/multiple file in SharePoint 2013 Library using Rest API. We can use the Content Editor web part to call the script files. Include Script files in Content Editor: Go to content editor -> Edit Source -> enter the code like below (code for including the script files) For 'jquery.min.js' we can either use direct link from online or we can download to our SharePoint library & We can use that. <script src=" https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js" ></script> OR use the below code <script src="/ sites/<SiteName>/<Subsite>/SiteAssets/jquery-1.11.1.min.j s"></script> <script src="/ sites/ <SiteName>/<Subsite> /SiteAssets/taskpage.js " type="text/javascript"></script> <script src=" /sites/ <SiteName>/<Subs...
Read more

Add content type to SharePoint List/Library using REST API

By -
Add content type to SharePoint List/Library using REST API Use this below code to add content type to SharePoint Library using REST API. For this you need to use the content type ID. Below function will get the content type ID from content type name & we will pass the content type id to next function which will update content type to list/library. var   varContentTypeName = " Your Content Type name "; var   Listname = " Your List name where you want to add content type "; //This will get the content type ID from content type Name function  getContentTypeID() { var deferred = $.Deferred();     var  isCurrentUserIsApprover = false ; var  serverURL = _spPageContextInfo.webAbsoluteUrl; var  listURL = String.format(" {0}/_api/web/AvailableContentTypes?$select=Name,Id,StringId&$filter=Name eq '"+varContentTypeName+"' ",serverURL); $.ajax({ url: listURL, type: " GET ", async: false, headers:...
Read more

A type named 'SP.Data. could not be resolved by the model error

By -
Image
When we are trying to update task list we will get this error " A type named 'SP.Data. could not be resolved by the model error. When a model is available, each type name must resolve to a valid name must resolve to a a valid type" This happens because there is a space in the list name. To resolve this issue we need to get the exact list name to be used in "SP.Data" 1.Use the below URL in chrome browser <SiteUrl>/_api/web/lists/GetByTitle('List Name')/ For Example:  https://SiteURL/_api/web/lists/GetByTitle('Workflow Tasks')/ Some times in Chrome browser you may get Authentication error. For that first open the list from your Chrome browser & then use the above URL. 2.Find "SP.Data" -> now you will get the list name that you can be used in SP.Data.ListNameListitem
Read more