Thursday, October 16, 2008 8:00 PMI would like to have a list populate data from a table in sql server.
I want the list to keep all its features like Sorting/filtering,delete,edit etc plus its item permissions options
Is this possible via SPD or from the Object Model.
Thanks in Advance
- Moved by Lionel Chen - MSFT Monday, October 27, 2008 3:01 AM If object model can help in this issue, move it to Development queue. (Moved from SharePoint - Design and Customization to SharePoint - Development and Programming)
Thursday, October 23, 2008 8:21 AMHi Patrick,
There is an article for your references:
However, I don’t think there is a way to keep all the features within SQL Server table.
If you need any further assistance via object models. I will help you move this thread to SharePoint - Development and Programming queue.
Monday, October 27, 2008 1:41 AMThanks Lionel,
But the sample you sent to me is good if i just want to export to excel and then keep using sharepoint as my interface.
But what i want is make the table in sql server in sync with my sharepoint list.
Monday, October 27, 2008 5:07 PMI did this exact same thing with the sharepoint web services - but you can use the object model as well.
Basically, you want to get the values from your database, then compare them to the values in your list and update, delete, insert accordingly.
I wrote an article on it here...
Tuesday, October 28, 2008 7:21 AMThanks Thomas .
I know web services could be an option just taught there would be another easier way.
In your article on your blog there is no web services sample there though
Tuesday, October 28, 2008 2:05 PMThat's true - there isn't. I ended up linking to the MSDN example of how to update list items through the web services. That should really give you all you need to know. The hardest part about doing that is composing the CAML correctly which is what I ended up focusing on. Here is the MSDN article again...
- Marked As Answer by Michael Washam - MSFT Wednesday, October 29, 2008 5:08 PM