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

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