• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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 asp.net. No idea so far.

Thanks for hint.
0
zhshqzyc
Asked:
zhshqzyc
  • 4
  • 2
  • 2
1 Solution
 
QPRCommented:
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
 
ivan_vaguninCommented:
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
 
ivan_vaguninCommented:
sorry, I meant "It has a functionality", not I )
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
zhshqzycAuthor Commented:
I installed Sharepoint Designer several times but failed. The error is "package failed" something like.
0
 
zhshqzycAuthor Commented:
Is there a similar snapshot so I can follow the sample?
0
 
zhshqzycAuthor Commented:
Admin PageI have a similar windows form application. How to implement it in Sharepoint?
Please see the image.
0
 
QPRCommented:
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
 
zhshqzycAuthor Commented:
Yes, run the right version as an administrator but failed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now