I am using AutoCRUD functionality.I have created a couple of SQLDataSource with Insert, Update and Delete auto geerated, they are then used as relational tables in a WebHierarchicalDataSource Which then is used to link to the grid; the data is loaded correctly, I can add a new row correctly and I can delete a row by selecting it.The problem is when I want to edit the row when I double click a cell it goes in the edit mode and allows me to type the text in (change the text), then I hit the enter button to confirm the changes. This doesn't updates the database right a way, even if I select another row the changes text is displyed in the grid but not updated in the database, Now if I do some other thing like expand collapse the child rows then the data is updated in the database.
I am now clueless what triggers the update in the database? is there any seetings required?
I tried setting the Edit Grid Baviour -> Activation -> AutoPostBackFlags -> ActiveCellChanged -> True, but this doesn't work either. Pease help me how can I make this work. I also made sure that the bands have the DataKeyFields poperty correctly set. Please help.
thanks
D
Hi again,
Mike D. from support today told me that in order for the commit() to work, you just need to have a server side event for the rowupdated event. That could give you the ability to update after exiting each cell.
Ed