123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Hardware-Software >> View Article

Microsoft Sharepoint Development - Creating External Lists

Profile Picture
By Author: lauren jafor
Total Articles: 10
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

One of the most acknowledged features of Microsoft SharePoint for Microsoft SharePoint development is external lists which have converted the MOSS 2007 Business Data Catalog (BDC) into Business Connectivity Services (BCS) in SharePoint 2010. It can be created independent of the SharePoint server as it is already included in Microsoft foundation. External lists though look like regular lists to an end user actually spread to external systems such as web services and databases.

Developers who have worked with BDC earlier know very well what a trouble it is to create external list. Heavy data XML files which contained the application definition were to be forged. This was a very massive task and developers often depended on external tools to make the task easier for them. The latest version of Microsoft SharePoint development that is SharePoint 2010 has made creating external lists really very simple, speedy and fast. A SharePoint developer can expose them under SharePoint 2010 in just 10 minutes if the database table is ready.

To create external lists for the customer external content type based on the customers ...
... table in Northwind database using Microsoft SharePoint development you will have to first run Business Data Connectivity Service Application. Ensure that it is running perfectly by going to central administration panel and click on manage service applications. Apart from this you will need external content type and Microsoft SharePoint Designer 2010 or the browser.

Server running SharePoint server should be equipped with Microsoft SQL Server 2005 or later, Northwind SQL Server 2000 database and customer external content type for creating external lists using Microsoft SharePoint development practices. To begin with move to SDK Samples SharePoint site from the Microsoft SharePoint Designer 2010. Click View All Site Content from the site's actions menu on the left. Click the create button and then click external list from the custom lists section. Here we will create a new external list by entering a new name and a small description for the list on a new page.

Type the name of the external content in the text box if you know the name of the content type in the data source configuration section or else use the picker to help you pick the right name. It lists all different external content types denoted in the metadata store of the site's service application's Business Data Connectivity (BDC) service. After selecting the type in Microsoft SharePoint development click external content type picker.

Now SharePoint developer can move to the new list in the SharePoint site to view and edit items in the list. It is not mandatory to work online you can easily move the list offline in SharePoint Workspace and Microsoft Outlook.

Similarly external lists for customers can be created using Microsoft SharePoint development. The beginning process remains the same as mentioned above with the only difference that you need to select customer external content type as the data source. Click the create lists and forms button as shown in the figure to open the create list and form for customer dialog box. Name the new external list as NWCustomers List, SharePoint designer will then generate external list.

Tatvasoft provides Microsoft SharePoint development services like project management, enterprise content, business process, portals and collaboration.

Total Views: 196Word Count: 543See All articles From Author

Add Comment

Hardware/Software Articles

1. Financial Consolidation Software: A Necessity In Today’s Complex Financial World
Author: BiCXO

2. Mobile Application Development Company: Innovating For The Future
Author: Quickway Infosystems

3. 2025's Top Choice For Casino Entrepreneurs: 7bitcasino Clone Script
Author: aanaethan

4. Online Admission Management Software
Author: Aditya Sharma

5. The Role Of Technology In Enhancing Student Retention
Author: Brenda Joyce

6. Capcut Template New Trends: A Glimpse Into The Future Of Video Editing
Author: Oliver Nash

7. Understanding Canva Mod: Is It Worth The Hype?
Author: Mason Brooks

8. How Custom Software Development Companies Are Revolutionizing Industry Solutions
Author: Digileap

9. Fintech Development Services: Catalyzing Innovation In Financial Technology
Author: Digiprima Technologies

10. Freight Forwarding Software: Revolutionizing Global Trade With Seaknots It
Author: seaknotsit

11. How Automatic Gst Compliant Invoice Generation Will Help Your Business?
Author: Bhumish Seth

12. Streamlining Prototyping With Cnc Router Technology
Author: CncRouter

13. Hp Laptop Screen Replacement In Malad
Author: Aquila IT Solutions

14. From Concept To Creation: Cnc Routers For Precision Prototypes
Author: CncRouter

15. The Benefits Of Custom Crm Development For Modern Enterprises
Author: Ashapura Softech

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: