About adding row in spreadsheet Grid

Title:

BI{code} ?

When adding a new row to the grid , why does it need to actually insert a blank row in database and then update it. What if the user exits the page, that will leave a blank record in database. I was hoping that the client api would be able to add a blank row which can then be sent all together for saving Db.Insert(new Spreadsheet()); What's the solution around this?. We are very close to completing the project using the trial version and buying this product.This is the only thing that's a bit for concern for us. Please provide help

Save Changes Cancel

Pareen

asked at 17 Jul 2014

• next version api will have the possibility to render rows and you would be able to insert it in the grid (the spreadsheet demo will be updated)
  at 03 Aug 2014 Omu

Answers

• BI{code} ?

  there are many ways you could approach this, you could display a temporary/inmemory collection and not go to the Db at all until you consider this necessary; you could use a flag on the row; keep new records in memory and union them with the db data before displaying; the *basic idea is you have complete control of the model that is being displayed in the grid* , also you have complete control on querying the data the spreadsheet demo http://demo.aspnetawesome.com/GridSpreadsheetDemo was made as simple as possible, to get a basic idea of how to do this, when you click "add row" a record is added to the Db and grid is refreshed

  Save Changes Cancel

  

  Omu

  answered at 17 Jul 2014

  • Thanks. The solution you provided is working. Looking forward to the next version which will have a client side row adding.
    at 03 Aug 2014 pareenvatani

please Sign In to leave an answer