ASP.Net grid control
-
I'm looking for an advanced grid control and have yet to turn up anything that quite fits my needs. I need something like an Excel sheet where I can cut/paste multiple rows/columns of data and be able to post all of this data back to the server. Everything I have turned up so far only allows editing of existing data, one line at a time. I've been looking into Office Web Components, and the Spreadsheet component would be great if I could just post the data in the sheet back to the server. It seems that the dataflow for these components is meant to be from server to client only. Can anyone around here point me in the direction of something like this, or give some pointers for creating such a control?
-
I'm looking for an advanced grid control and have yet to turn up anything that quite fits my needs. I need something like an Excel sheet where I can cut/paste multiple rows/columns of data and be able to post all of this data back to the server. Everything I have turned up so far only allows editing of existing data, one line at a time. I've been looking into Office Web Components, and the Spreadsheet component would be great if I could just post the data in the sheet back to the server. It seems that the dataflow for these components is meant to be from server to client only. Can anyone around here point me in the direction of something like this, or give some pointers for creating such a control?
We had this need for a project recently and ended up letting users have regular Excel spreadsheets for data entry (we had a form set up and the sheets protected). Then we provided an upload form with server-side code which captured the data from the sheets (done through ADO.NET treating Excel as a data source). To be sure, there's plenty that can go wrong with this setup, but if you structure the spreadsheets well, it can work. We conducted a survey of over 700 people (with a variety of Excel versions and PC and Mac platforms) using this technique and it worked well for us.