>>>Now we put code in RowDeleting (my colleague's attempts) and the RowDeleted event is never fired as well as this code doesn't seem to do the job. Can you help a bit here?
>>
>>I don't think RowDeleted fires when you're manually using your own dataset instead of the SqlDataSource.
>>
>
>
>>Calling Delete on the row just flags it for deletion.
>
>So, the row is supposed to be deleted automatically, correct?
>
>You have to call AcceptChanges() on the DataTable.
>
>Can you please elaborate on that? Our delete should not be a delete, it should set Deleted flag on the table.
>

Your code is pulling the DataSet out of the Session. When you called Delete() on the row, that sets a flag on the row that it's to be deleted. If that's all you're doing you won't see the row get removed. You have to call AcceptChanges() before it's removed from the datatable (not from the database). There isn't any update happening to update the backend. Something like a DataAdapter would be necessary for persistence to the database; in your code, you're handling deleting it out of the database so that's not even necessary.

>you mean run even this simple UpdateCommand with parameter, correct? In fact, I have a little SP for this as well, so we may call it instead with parameter.

Yes.