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

When I add new item into the list, I have to insert the items into the SQL database. How can I do it? Any clue is good for me.

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

Out of the head here, but can`t this be done if you add a database as a Data Source and set the Create All Operations on Table in BDC to work with the Database?

See also this tutorial.

EDIT:

Here is another tutorial explaining in detail how to connect to a Database. It should be pretty straightforward with this.

share|improve this answer
    
I followed the video. I created Datasource but how can I insert list items into this datasource? –  e.ozmen May 17 '13 at 11:48
    
It is in the video. The author creates a new list, and manipulates the data in it. I've edited my answer with another tutorial wich should help you. –  dzookatz May 17 '13 at 12:11
    
It worked. Can you tell me how can I modify the new form for this list. I can't create a dropdownlist for a field. –  e.ozmen May 20 '13 at 7:26
    
I think that this is a new question. But, you can create a new Page and then add the List to it. From there you can manipulate the List as you want through "Modify View" List option. And if you are asking how to add a dropdown option, this is set when you initially create the List, or edited with the "List Settings" option. –  dzookatz May 20 '13 at 8:17
    
I will explain it in the new question.Because it's not what I want. Thank you anyway. –  e.ozmen May 20 '13 at 8:31
add comment

There is also a 3rd party tool called BDLC which I have used in the past. Very easy to set up and configure and basically allows you to create either a read-only or write-back synchronised list and database table.

share|improve this answer
    
It looks good too. I'll try it with another list. Thanks. –  e.ozmen May 20 '13 at 7:25
add comment

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.