Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How Do You Populate a SharePoint List Difinition from MS SQL Server Table?

Posted on 2011-04-22
3
Medium Priority
?
731 Views
Last Modified: 2012-05-11
I created a SharePoint List Definition project in Visual Studio 2010 and published the solution to a SharePoint site.  How do you populate the List Definition from a MS SQL Server Table?  Do you know of some examples?

Thanks,

Dan
0
Comment
Question by:danielolorenz
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
zabiullah earned 2000 total points
ID: 35455132
You can use

1) BCS(Business Connectivity Services - External List/Content Types) - *External List is not stored in the SharePoint 2010 content database.
Reference:
- http://www.sswug.org/articles/viewarticle.aspx?id=47401
- http://www.mstechblogs.com/sharepoint/how-to-step-by-step-creation-of-external-list-in-sharepoint-2010/

2) SSIS (Microsoft SQL Server Integration Services) & SharePoint List Source and Destination Adapter project on Codeplex
Reference:
- http://www.petestilgoe.com/2011/01/populate-a-sharepoint-list-from-an-sql-database/
- http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

HTH,
- Zabi
0
 

Author Comment

by:danielolorenz
ID: 35460026
Zabi,

Excellent help.  I am required to load the SharePoint List Definition using Visual Studio and making the MS SQL Server connection there.  Do you know how to load the list definition using Visual Studio to SQL connection?

Thanks,

Dan
0
 

Author Closing Comment

by:danielolorenz
ID: 35467756
Excellent Help
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question