To All,
I am unable to use AutoCRUD with the data requirements imposed on me. I need to be able to manually update the underlying database whenever a customer changes the data in a WebDataGrid row. Those changes have to be reflected in the underlying database and on the presentation immediately.
I have reviewed the RowUpdating event, but it seems to batch update when a user clicks on something that forces a page update.
I need something that will allow me to have the customer update two cells and fire when he/she either changes rows or does something that triggers a page update.
Hello,
Thank you for contacting us.
Let me know if I am missing something from your scenario, as I understand you want to persist all changes made in the grid to the DataSource by your own custom code. In that case. In that case you should perform manual CRUD, for more information please refer to this blog.
Zdravko,
I found the blog post you mentioned a couple of days ago. I might not have been clear on what I am trying to accomplish.
What I need for my customer is the ability to enter data in one column of the WebDataGrid, go to the next record and enter data in that same column, and so on. The customer will be using a barcode scan gun. A single cell in each WebDataGrid row will be filled in either manually - or more likely via a barcode scan gun. Most likely I will 'keyfake' in either the <Enter> key or the <Arrow Down> key to save the necessary data to the physical database (there are three tables that have to be updated) and then the following row will be Selected/Activated and the Serial Number cell will be Selected/Activated for data entry. The customer then scans the next barcode which is then updates the physical database and the beat goes on.
Also, Zdravko, the blog you linked to has an exeptional discussion on manual CRUD - which anyone with questions on this process should read. However, the discussion on manual record Updates requires the customer to select a row and then a template form is generated with <Cancel> and <Done> buttons. I really cannot have a slow manual data entry process for this task. My grid will have hundred(s) of rows and potentially multiple operators and both the grid and database needs to be updated on a transactional basis - not batch, and not manual one-by-one point and click. I need the operator to start at the top row and barcode scan a serial number, save the record, and then have control passed to the same cell in the following row.
Thank you for the provided details.
As I understand you want the customer to be able to type in values without to bother to some additional clicks and buttons. To iterate from one column to another just by hitting enter or another key, and to be able to change the values fast, by column, not by row. I have created a sample for you which is performing exactly this, when a cell is in focus automatically starts to be in edit mode and on tab key press exit edit mode is performed and the cell below start to be edited.
Please have a look at the attached sample.
I'll look into this option. I will have to have some server side record management to deal with updating other data elements, but this looks promising. I fully expect that your answer leads me in the right direction.
Roger