Skip to main content

External Lists in SP2010

External lists in Sharepoint 2010 can be used to read/add/update/delete data in any external data- source.

To create external list, a external content type has to be created.
Refer the below links on msdn on how to create external content type
How to create external content type
Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010
Sharepoint-2010-external-content-type-to-read-data-from-sql-server-using-sql-authentication-and-secure-store-service.aspx

The below links explain on how to create external list
How to create external list
https://www.nothingbutsharepoint.com/sites/eusp/Pages/sharepoint-2010-external-lists.aspx

More about BCS functionality in msdn
http://msdn.microsoft.com/en-us/library/ee557949.aspx




Labels:

Comments

Post a Comment

Popular posts from this blog

How to link to Download a copy option in Office 365/SharePoint 2013

At times it is required to have the option to save a copy of a document uploaded in SharePoint document library, in a page or a webpart. The url to get the save option for a doc is - http:// site /_layouts/download.aspx?SourceUrl= url-of-document-in-library Change the bold text with the actual url, i.e., with the site url and the url to the doc in the doc library. For example, if the site is www.contso.com and the doc "Test" is uploaded in SiteAssets library, the url to save a copy would be - http://contso.com/_layouts/download.aspx?SourceUrl=http://contso.com/SiteAssets/Test.docx
1 comment
Read more

Redirect to a desired page on click of submit/ cancel button in infopath form

By default, when a user clicks on Submit/Cancel button, the InfoPath list form redirects to the AllItems.aspx page of the list. Instead of redirecting the user to the default view of list, to redirect it to the desired page, append the URL of the InfoPath form with &Source=redirect-url http://xyzportal/..../xyzform.xsn&DefaultItemOpen=1 &Source=redirect-url Also, make sure that in the button properties, in the "Browser Forms" tab, "Always" option is selected.
Post a Comment
Read more

Cannot open SharePoint 2010 Approval task form from Outlook

When trying to click on Open this task from Outlook 2010, it brings an error - " Outlook cannot open a new form. The form contains schema validation errors" Element '{ http://www.w3.org/1999/xhtml}div ' is unexpected according to the content model of parent element '{ http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields}Body '. As given in the error message, the issue is with the Body column of the workflow tasks list. For the approval workflow, there would be a tasks list. In the workflow task list, the Body column is Enhance Rich multi-line column. Change the setting to Plain text, instead of enhanced rich text. After that do an iisreset.
7 comments
Read more