making cells editable in GBDG

[Administrator]

Hi,

Is there a way to have certain columns of a GBDG user editable without any sql update,delete,insert sql in the sqlDataAdapter? its a multiple table select which is why i''m having a problem. Do I have to go to a gridcontrol?

thanks

[Administrator]

If the underlying datasource is not editable, then the grid has nowhere to store the changes as it cannot put them back into an uneditable datasource.

Even if you use a virtual grid, you would probably not be able to save the changes back to your datatable in SaveCellInfo.

You could move the DataTable into a GridControl using PopulateGrid, and just let teh grid maintain the information in its internal GridData object. Then if you want to try to push teh changes back to your database, then you would have to get the information from teh grid back into a updateable table.