How to cancel deleting a row in an event

[Hamed]

Hello

I need an event to be able to cancel a delete request to a DataRow object in
some conditions. It seems DataRowDeleting should be able to do the job but
setting e.Action is impossible (it is read-only)

How can I do the above job?

Thanks in advance
Hamed

 

[Hamed]

I need an event to cancel deletion of a DataGrid row that the DataTable is
bound to.

 

[Cor Ligthert [MVP]]

Hamed,

Reject changes is fine, not only for deleting.
(Be aware that it does not work for removing)

http://msdn2.microsoft.com/en-us/library/system.data.datarow.rejectchanges.aspx

it is there as well at datatable and dataset level
http://msdn2.microsoft.com/en-gb/library/system.data.datatable.rejectchanges.aspx

Cor

 

[Miha Markic [MVP C#]]

I think that the only way is to throw an exception.
An ugly way btw.

 

[Cor Ligthert [MVP]]

Hamed,

Reading your question over. Probably is this on our website your answer.

http://www.vb-tips.com/dbpages.aspx?ID=740184e1-a6df-4e31-8417-a1741d691945

I hope this helps,

Cor

 

[Hamed]

I think that the only way is to throw an exception.
An ugly way btw.

I read some threads such as the following but isn't there really a more neat
method to do the job?

http://groups.google.com/group/micr...+delete+datagrid+.net&rnum=2#7fdc4a9383662d26

 

[Hamed]

Thanks Cor but in the code you mentioned if a cell is selected but the whole
row is not selected, it will be deleted that is not a desired occurrence.

any other suggestion is appreciated

Hamed

 

[Miha Markic [MVP C#]]

Honestly, I give up on controlling/cancelling row deletion. Instead I don't
allow deletion before it happens..