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.


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.


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

  • 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

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.

  • It looks good too. I'll try it with another list. Thanks. – e.ozmen May 20 '13 at 7:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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