View, Edit and add tables

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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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)
sorry, I meant "It has a functionality", not I )
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

zhshqzycAuthor Commented:
I installed Sharepoint Designer several times but failed. The error is "package failed" something like.
zhshqzycAuthor Commented:
Is there a similar snapshot so I can follow the sample?
zhshqzycAuthor Commented:
Admin PageI have a similar windows form application. How to implement it in Sharepoint?
Please see the image.
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.
zhshqzycAuthor Commented:
Yes, run the right version as an administrator but failed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.