Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there a way that i can populate a custom share point list into a table in SQL server Database . I have a custom list which i modified it and made it as an info path form and on submit i want that the values entered by the user must be populated in a SQL table ..Please help me

Thanks

share|improve this question

3 Answers 3

up vote 0 down vote accepted

This will probably help you (from Codeplex): Microsoft SQL Server Community Samples: Integration Services

With the above app you can transfer data between SharePoint and SQL Database (both ways). With some sql server jobs, you can keep data relatively synced, not dynamically though. The product is free.

share|improve this answer

I agree with Gennady, but if you insist than you can create a SharePoint list item event handler and on "ItemAdded" event and then you fetch all the list item column values by SharePoint object model.

Once you have performed this step you would then need to make a stored procedure in the SQL database to SET the data in. Another good step is to first check to see if you not returning the same values into the database to save on resources so that only new data get persisted on to sql server.

This is a nice little article that might help you out that you could change to suite your needs http://www.directsharepoint.com/2011/02/dump-sharepoint-list-data-into-sql.html

hope this helps

share|improve this answer

If you want:

  • "i want that the values entered by the user must be populated in a SQL table want "the values entered by the user"

then you shouldn't have made

  • "a custom list which i modified it and made it as an info path form and on submit"

which I understand as Infopath form was made by pressing a violet button "Modify Form" on ribbon.

In this case the "the values entered by the user" are already persisted by Infopath form of type/compatibility "Sharepoint List Form" through auto-created and locked as non-modifiable during Infopath form creation Main Data Connection (of type Main Data Source) onto a sharepoint list.

The sharepoint list data is stored by Sharepoint server into SQL Server Content database for you automatically by design. And this is unrelated to Infopath

Any reason why do you want to persist data redundantly both into a sharepoint list and into a custom SQL Server database?

Update:
I also wrote initially...
Either it is possible through Sharepoint what is most probably not your intention when you asked about submit from Infopath form. From Infopath you should not do it through Sharepoint List Form...
While it is possible to do from Infoapth, you should have asked WHAT you want to do but not HOW (eventually you can not).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.