Solved

View, Edit and add tables

Posted on 2012-03-20
8
263 Views
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 asp.net. No idea so far.

Thanks for hint.
0
Comment
Question by:zhshqzyc
  • 4
  • 2
  • 2
8 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 300 total points
ID: 37745500
If you already know asp.net 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
0
 
LVL 18

Expert Comment

by:ivan_vagunin
ID: 37745898
Hi!
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)

http://technet.microsoft.com/en-us/sharepoint/ee518675
http://msdn.microsoft.com/en-us/library/ff728816.aspx
0
 
LVL 18

Expert Comment

by:ivan_vagunin
ID: 37745899
sorry, I meant "It has a functionality", not I )
0
 

Author Comment

by:zhshqzyc
ID: 37746910
I installed Sharepoint Designer several times but failed. The error is "package failed" something like.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

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

Author Comment

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

Expert Comment

by:QPR
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.
0
 

Author Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

937 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now