.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

Can Information inside of SP 2010 lists be pulled systematically to and SQL DB?

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :SharePoint
 
We have a team that wants a few fields of data pulled from the SP list directly to an existing SQL database. Can this be done and if so...what app would we need?
cindi bethel carmona


View Complete Post


More Related Resource Links

WSS Lists - Lookup field information missing in Excel 2010

  
Hi, I've got this xls workbook which contains a two-way synchronized SharePoint list. This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source. In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in this combobox and synchronizing. This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell isn't among available values. Is there something special I should do to enable this feature in Excel 2010? Regards, Carl 

How to get more information about the exceptions that can happen in SharePoint 2010 projects?

  
In case there is an exception anywhere in the SharePoint 2010 project (most common place an exception would happen is during deployment of your SharePoint project, custom deployment configuration or custom deployment steps), there's a registry key EnableDiagnostics available for you to use.

Chapter 3: SharePoint Developer Tools in Microsoft Visual Studio 2010 (Inside SharePoint 2010)

  
Learn what's new with the SharePoint developer platform from experts on Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.

Chapter 4: Sandboxed Solutions (Inside SharePoint 2010)

  
Sandboxed solutions represent a new form of solution deployment and management in SharePoint 2010. Learn how these solutions balance agility with farm stability and are considered a best practice for SharePoint developers.

Chapter 2: SharePoint Foundation Development (Inside SharePoint 2010)

  
Learn what's new with the SharePoint developer platform from experts on Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.

Developer Training: User Interfaces and Lists in SharePoint 2010

  
Learn about the new user experience in SharePoint 2010 and how you can use the new UI in your customizations. This training module also discusses improvements in list handling, including list relationships and new form-rending options.

Chapter 1: SharePoint 2010 Developer Roadmap (Inside Microsoft SharePoint 2010)

  
Learn what's new with the SharePoint developer platform from experts on SharePoint Foundation 2010 and SharePoint Server 2010.

Quick Note: Accessing Multiple SharePoint 2010 Lists by Using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from three lists by using LINQ queries and displays the results in a grid view control.

Quick Note: Add Event Receivers to SharePoint 2010 Lists

  
In this exercise, you add an event receiver to a custom Microsoft SharePoint 2010 list that is triggered when you attempt to delete an item in the list.

Quick Note: Create Lists with Custom Content Types in SharePoint 2010

  
Learn how to create a list in SharePoint Server 2010 and associate it with a new content type. Next, you disassociate the list from the content type and then delete the list.

Video: SharePoint 2010 Lists, List Data, and CAML

  
This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

Managing Lists On the Quick Launch Bar In Sharepoint 2010

  

Hi can somebody help please.

I am using Sharepoint Foundation 2010 and I need to use the "navigate function" that you use to have in MOSS 2007.

Basically I want to be able to move lists between different sub headers on the quick launch bar. In MOSS 2007 I use to be able to go into manage site settings and choos "navigate and then move the lists up and down between the sub headers that i created on the quick launch bar.

Anyone got any ideas

Cheers

mike


How to get rid of the (More Links.) link on lists in SharePoint 2010?

  
I have a list of 5 items. The view settings are set so that the Item Limit is 20. I would like the eliminate the (More Links...) link under the list when the web part is on the page. I also tried setting the Toolbar properties to No Toolbar. Any ideas? Thanks.

Information Worker 2010 VM - Is boot from VHD possible

  
I've downloaded the Information Worker 2010 VM from: http://www.microsoft.com/downloads/details.aspx?FamilyID=751fa0d1-356c-4002-9c60-d539896c66ce&displaylang=en I don't have a Windows 2008 R2 Hyper-V Host to test this out on (only got Windows 7 on my laptop at present), does anyone know if it's possible to use the VHD as a bootable VHD? I simply tried to add a bcdedit entry to point at the VHD but when I tried to boot it blue-screened and restarted my laptop. Does this require running the bcdboot command on the VHD? Cheers, Colin

Information Worker 2010 - Web applications do not show up

  
i have Information Worker 2010 VHD running on VMware-MacBookPro with 6Gb ram. I converted vhd to vmware and it runs fine but for watever reason am unable to bring up the various web applications in the VM. I can goto Central Admin but the web applications (each is configured with a host header) simply dont show up.  i googled for hrs and have tried DisableLoopback thread etc., checked dns entries but nothing helps. What am trying is definitely not to be done in a production env, which is running web app on local server. has anyone been able to bring up web apps successfully. 

how to Join two SharePoint Lists in SharePoint 2010

  
I have one Document Library and One List, just want display data from both based on ID in SharePoint 2010. Document Library : "Doc1" having following columns 1. ID (default column) 2. Title 3. Description 4. Image Url List : "List1" having following columns 1. RefID ( lookup column, refers the doc1 ID column) 2. Created By I want to display get data table for what are the ID's(items) created by me using CAML Query (SPQuery.Joins)  

Join two Lists/Library in SharePoint 2010

  
I have one Document Library and One List, just want display data from both based on ID in SharePoint 2010. Document Library : "Doc1" having following columns 1. ID (default column) 2. Title 3. Description 4. Image Url List : "List1" having following columns 1. RefID ( lookup column, refers the doc1 ID column) 2. Created By I want to display get data table for what are the ID's(items) created by me using CAML Query (SPQuery.Joins) Pls give me solution... Thanks in adv...
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend