How to update datasource when changing column only (not row)

[Hal McKinney]

Hello,

Appearantly the only time the underlying datasource in my databound grid is updated is when I change rows. I want it to update whenever I change cells, even if it''s to a different column on the same row.

(I thought maybe the .RefreshCurrentCellBehavior was the answer while searching your board but it didn''t seem to affect anything)

-Hal

[Administrator]

Hi Hal,

Try calling gridDataBoundGrid1.Update() in CurrentCellChanged or CurrentCellAcceptedChanges event and see if that helps.

Regards,
Calvin.

[Hal McKinney]

I don''t think any of that worked.

The CurrentCellChanged/AcceptedChanges events fire BEFORE making changes to the current cell and the grid.Update() still doesn''t appear to force a recalc of other columns on the same row until I move off the row.

[Administrator]

Hi Hal,

Sorry for the inconvenience. Calling this.gridDataBoundGrid1.Binder.EndEdit(); in the CurrentCellAcceptedChanges event will update the underlying data source when a cell value is changed.

Thanks,
Calvin.

[Hal McKinney]

Thanks Calvin,

That did the trick.

[juan velez]

SI