View, Edit and add tables

Posted on 2012-03-20
Last Modified: 2012-03-28
I am going to develope a sharepoint application. One of this is allow admin to view, add and edit tables that are from database.

I am newbin for sharepoint but strong on No idea so far.

Thanks for hint.
Question by:zhshqzyc
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
LVL 29

Accepted Solution

QPR earned 300 total points
ID: 37745500
If you already know then the easiest path might be for you to use a gridview in a aspx page.
Create a new page in sharepoint designer and insert (aspx controls) a gridview.
From there everything will be very familiar to you... connectionstring, sql command, edit columns, specify primary key so you can generate insert/update/delete statements.
It's very much the same as the wizard in visual studio
LVL 18

Expert Comment

ID: 37745898
Look at SharePoint 2010 Business Conectivity Services - I has a functionality that allow to you work with external database tables, just as ordinary SharePoint lists (this can be done even without coding for simple scenarios).

SharePoint BCS is available in Server edition only (not in Foundation)
LVL 18

Expert Comment

ID: 37745899
sorry, I meant "It has a functionality", not I )
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now


Author Comment

ID: 37746910
I installed Sharepoint Designer several times but failed. The error is "package failed" something like.

Author Comment

ID: 37746968
Is there a similar snapshot so I can follow the sample?

Author Comment

ID: 37747070
Admin PageI have a similar windows form application. How to implement it in Sharepoint?
Please see the image.
LVL 29

Expert Comment

ID: 37749585
did you try right clicking on the sharepoint install file and selecting run as administrator?
Have you got the right version 32/64 bit for your operating system.

Author Comment

ID: 37749654
Yes, run the right version as an administrator but failed.

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sharepoint 2013 calendar change like sharepoing blog formate day above month 1 104
Working with SharePoint Data 8 75
Masterpage unexpected error 7 47
Sharepoint Online 5 118
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In a recent question ( here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question