Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
240
Auto CRUD on edit won't always update database
posted

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

 

Parents
No Data
Reply
  • 5739
    posted

    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

Children
No Data