How to link data in sharepoint list to Sql server tables

Question

I 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

Answer 1

Hi Patrick,

 

There is an article for your references:

 

http://fuchangmiao.blogspot.com/2008/05/import-sql-table-as-sharepoint-list.html

 

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.

 

Regards,

Lionel

Answer 2

Thanks 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.
Any ideas?

Answer 3

I 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...

http://armsinfragilehands.blogspot.com/2008/08/updating-items-in-sharepoint-list-part.html

Answer 4

Thanks 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

Answer 5

That'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...

http://msdn.microsoft.com/en-us/library/ms440289.aspx