How can i recreate a spreadsheet or sharepoint datasheet view on a website ?

Question

I am trying to migrate users off of a sharepoint solution into a website + SQL backend. The one thing is that everyone seems to like the sharepoint view and the data sheet view for editing and managing information.

what is the best spreadsheet / access data editing solution. are there any third party asp.net mvc widgets that are good alternatives

Answer 1

Telerik's Grid for MVC is supposed to be good, but you may want to consider an alternative to the traditional grid UI experience.

The MVC paradigm does not explicitly define how you should do things- that's one of it's many strengths. But it does however encourage users into certain directions: testing; maintainability; separation of concerns (logical isolation); design patterns; user experience; user centered design; etc, etc. With this in mind is there an alternative to a grid that you may be able to use? Repeating elements? In line editing (think Facebook comments)? Don't show all items, just the top 10 most relevant to the user? Live Search to filter without all the options? Maybe you can create a better experience for the users without a grid, and now that you're going to use MVC, this is the best time to do it.

See how easy it is to turn something sad looking

..into something happy

Keys ideas:

• Remove the fluff
• Some things are obvious
• Search is capable of figuring out stuff by itself
• and the popular: Less is more

Answer 2

Have a look at Matt Berseth's blog, he has done some amazing stuff with the listview control (and other ASP.NET cotrols).

The following link might be specificly to what you are looking for:

Bulk Inserting Data with the ListView Control

and a example:

Bulk Inserting Data with the ListView Control - Live Example

Answer 3

This one has some limitations (only works in IE), but some commenters say it meets their needs. it "a Grid which has resizable columns, a Grid which has resizable rows, a Grid which has editable cells, a Grid whose cells can be navigated by using the arrow keys and the Tab key, a focussed cell in the Grid which responds to the key strokes when a user starts typing."

And here's another one that might suit your needs, a "fully editable GridView".

Answer 4

Telerik (good MVC support) or JqGrid (free) are very nice. If you want a more spreadsheet approach, have a look at jquery.sheet.