Glad you found the problem, Rene. =)
~~Bonnie
>Hi All,
>
>Thank you for the reply.
>I have already solve it.
>The problem is my code.
>There is some part of my code that cause the error.
>There is no problem with the delete and update method.
>
>Sorry for late reply.
>
>
>>Larry,
>>
>>Yes, sometimes the .EndEdit() is necessary to "commit" changes to a DataRow that's been changed, but note that this is a DataRow method, not a method of the DataSet.
>>
>>In any case, I don't think this would not be the cause of the error that Rene was encountering. Somewhere, he's trying to access a column in a Deleted row in his DataTable.
>>
>>The DataRow's HasVersion() method determines whether a DataRow is still in the Proposed state (DataRowVersion.Proposed ... in which case, an .EndEdit() is needed), or Current or Original ... a column in a Deleted row can only be accessed by accessing the Original version.
>>
>>~~Bonnie
>>
>>
>>>Rene,
>>>
>>>What you might try before calling the update method is to call the DataSet's EndEdit method. I don't know why but it has cleared up problems I have had in our projects. objDataSet.EndEdit()