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.
Add a comment
|
2 Answers
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.
-
I followed the video. I created Datasource but how can I insert list items into this datasource?– e.ozmenCommented May 17, 2013 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.– dzookatzCommented May 17, 2013 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.ozmenCommented May 20, 2013 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.– dzookatzCommented May 20, 2013 at 8:17
-
I will explain it in the new question.Because it's not what I want. Thank you anyway.– e.ozmenCommented May 20, 2013 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.
answered May 17, 2013 at 12:15
