Hi,
I'm looking for some advice regarding in-place editing of a grid bound to an entity collection, something similar to how MS-Access works when entering data directly into a table.
With my experiments so far if I set the DataSource of a grid - in this case a DexExpress Grid - to the entity collection and then listen for events of the collection, when I start to enter data into a new grid row the EntityAdding, ListChanged, EntityAdded events are fired immediately.
This is kind of expected as the grid must create an empty row with which to store the data. But unfortunately acting on these events is no good at this point because the row is essentially empty except the first character of the first field entered, so there's no point trying to validate and persist at this point. So i'm not sure when to start listening to events. I would ideally like only to receive an event before the focus leaves the row so that I can try to save that row, and if an error occurs I can cancel the focus change event and highlight what the issue is, exactly how Access works.
Unfortunately i'm stuck how to achieve this. Can anyone offer a simple databinding example with persistence using the adapter?
Thanks.
