Creating an External Content Type using SharePoint Designer
1. Open visual studio 2010.
2. Click on data menu in Visual studio 2010.
3. In Data menu select Transact-Sql editor.
4. In that click new query connection.
5. Select Server Name for Sql server & select authentication as windows.
6. Give server name as (local).
7. Now your Sql server will open for you. Create a database & table you want or use an existing data or table.
8. Now open SharePoint designer 2010.
9. Give your SharePoint site URL and click on open.
10. Now click on site tab in SharePoint Designer 2010.
11. Now click on external content type at the top of SharePoint Designer 2010.
12. Now click on click here to discover external data sources and define operations link.
13. Now click on Add connection.
14. Now select datasource type as Sql Server.
15. Now giver your server name as (local) and in database as your database name & choose the option Connect with users identity & press ok.
16. Now select you table in that connection.
17. Now define your operations you want to do on that particular table.
18. Now save your external content type.
19. Now open your SharePoint 2010 site.
20. Create an external list with the selected external content type.
21. Now click on create.
22. Now you will get all the columns what you have mentioned within your Sql server table.
23. Perform any operation you want.
24. It will automatically reflect in your Sql server at the backend.
No comments:
Post a Comment