>>Originally we were using SQLDataSource. The DeleteCommand was set to be "Update People set Deleted = 1" In RowDeleted event there was a special handling to show a message with a button to undelete.
>>
>>Since we switched to just DataSet for the GridView DataSource this functionality stopped working. My colleague added a code to delete a record in RowDeleting method using direct update of the data, but the code doesn't seem to work.
>>
>>My original idea was to set Grid DataSource to SQLDataSource and somehow "refresh" the underlying DataTable when we retrieve a new DataSet. However, I never figured out if this is doable and in the meantime my colleague changed approach to always set GridView datasource to the DataSet.
>
>
>Use the dataset as the datasource, but get the dataset by using a DataTableAdapter FillMethod. by using the table adapter, you have access to select, insert, update, and delete methods.
I see, we'll try to investigate this approach.
If it's not broken, fix it until it is.
My Blog