Follow the below steps one by one
Step 1: Create an External Content Type
Step 2: Create an External List
That's it! You have created your forms, but wait, you still need to give permissions to the BDC you had created a while ago to perform the needed operations.
Step 3: Configure Business Data Connectivity Service (BDC) Permissions
Now, you need to assign permissions on the Business Data Connectivity Service you just created, and you can do that by going to Sharepoint 2010 Central Administration. Once there, go to Application Management, then Manage Service Applications.
Step 4: Try Out What You Had Created
Now go to your Team Site, then on Lists, and you should see the External List you just created and this works similar to a normal Sharepoint list where you can add, edit and delete items.
Until this point, you haven’t coded anything and it's mostly configuration, imagine doing this as a separate application. You will definitely code a lot of stuff and you won't just worry about the forms, but as well as the design and security aspects of it. You also need Visual Studio or any IDE that can develop applications like such, but with Sharepoint 2010 everything is handled for you like the security, design, content management and most importantly, the operations you needed for a table and best of all, if you or your company is stingy you can do it all for free as there is a free version for Sharepoint which is the Sharepoint Foundation 2010 and also the Sharepoint Designer. So go ahead, give it a try and definitely it will increase your productivity and you can concentrate on more gruniter tasks.
Refer:
One
Two
Three
Nice post!
ReplyDelete