Cellvalidating change value
Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S._event which executes my function changing the value of the cell to 0) --focus is now on the cell to the left of original cell, but the original is still blank- Yet value is 0.to to display the new value after it has been changed during the Validating event?I have a databound custom grid the inherits from Data Grid View and I have used the On Cell Validating event handler to check whether what was entered in the Combo was in the items list.The event fires, the form consumes the event, the new record is created, the database is updated, the combo data is reloaded, and everything should be fine....BUT: In the specialised grid there is a simple routine that reloads all the items into the combo and then RESETS THE UNDERLYING CELL VALUE in the grid: public void Update Nominal Accounts(long id) Now we are at the crux of the matter.
This event can be consumed by a form containing the grid, and used to allow the user to create a new entry and load it into the database. However, having created the new entry I need to set the value to the id of the new entry as shown in the example code below. "The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years.Most of what I am about to explain is technically irrelevant to what should be a fairly simple question, but hopefully it will help to point in the right direction :-) You mentioned "Not In List event", but I don't see how that fits in, or if it is even important...It is not important, it is CRITICAL - without it there would be no problem :-) The whole point of the process is to enable 'on the fly' addition of items to the combo within the grid.This is very simple code to create the event in the ancestor grid: public event Event Handlernt Args e) On the form the On Not In List event would be consumed, and a new entry created.
It will then be stored to the database (in the case I am working on, but it could just as easily be an IList or whatever), and the grid instructed to reload whatever list has been updated: private void expenses Advanced Grid_Not In I am trying to figure out what you mean by "everything I would expect to happen happens including the value being reset and retained correctly. The key thing to understand is that this all works PERFECTLY.I am trying to figure out what you mean by "everything I would expect to happen happens including the value being reset and retained correctly.However, the cell is not updated with the value."...I have to put focus back on that cell and then leave again to get the new value to display. Or is there an event I should fire to cause the cell to update???