Hi Folks

This is a general question not associated with any particular project but I'd like to get some opinions.

I often find myself wanting to use a grid to display a result set and want to let users edit the contents of the grid directly. Every time I do this I find myself crowbarring the functionality of one grid or another to make it fit what I want to do.

A datagrid seems the way to go on the surface but I find it to be inflexible and it's not great at handling calculated columns (ie a column that's calced from the db but doesn't map back to a specific individual column). I also find the whole concept of manipulating the datasource rather than the rows in the grid to be counter-intuitive, I'd rather detect a change event and then reflect the change back to the db or possibly write all changes back when the form closes.

The flexgrid gives me the sort of control I'd like as I can manipulate columns, cells etc from code without needing to worry about the underlying datasource but it's not editable (I think - if it is then please tell me how). I've even ended up floating textboxes over the current cell to make it appear editable but that can be a major hassle and tends to fall apart as soon as scroll bars get involved.

So what's my ideal grid? One where I can manipulate the contents and columns directly from code and handle user changes myself but which allows the user to actually chenge the contents of a cell. Any suggestions?