I have a DataGridView that is loaded with data from a readonly SQL view (actually via a SF BO). However, I do need to allow edits. I'd like to just react to the edit event, do my own thing (update data myself), cancel the editing that the datagridview attempts (which will fail), then update the gridview so it shows the new data. I'm sure this is easy, but I can't seem to get a handle on it. Ideas?

If I set the datasource of the grid to a datatable retrieved from a GetDataTable function in the BO, is the table still linked back to the source data?



If it isn't, then I could change the bound column, but the change wouldn't attempt to propagate back to the db.

No, if you bind the return value of the GetDataTable to the grid, the grid will not be bound to the business object.

OK, I got it to work!



I used a DataGridViewButtonColomn. The rules involved were too complicated to just allow the user to select a value anyway. In the CellContentClick event handler, I can call the stored procedure (via a BO of course), and then update the BO no problems.



If I had to allow the user to select a value, I'd probably try configuring the readonly BO to allow updates via a stored procedure.



That was a tough one! Thanks!

Not sure that I helped much, but I might have made you look in a few new directions... glad you got it working