update/delete fails when row contains null values
Hello ... I have a form that is straight forward, with little code behind (code is for a more friendly error msg when attempting insert,update, delete from a detailsview). I have had this problem before and the usual fix of reconfiguring the sqldataAdapter and detailsview does not work. The problem is when I have a row that contains column with a null value it will not update or delete. I can insert the row with a column that contains a null value, but cannot update or delete it. There is no error or exception thrown, the row simply fails to update or delete.
I am curious to know if anyone else is having this problem? If so what did you do to fix it?
Any information is certainly appreciated ... Thanks!