Hi,
here is my problem:
I am writing a form to make some changes in the details of some
employees. I use a combobox to select the Social Security Number and
retrieve the details of a specific employee. So far so good. The
details are retrieved ok. I use the BondingContext.Position =
cmbBox.SelectedIndex to move through the records of the dataset.
The problem is that if I change the details of an employee and then
press the "Update" button that I have (which calls
dataadapter.update()) WITHOUT FIRST MOVING TO ANOTHER RECORD USING THE
COMBOBOX, the changes are not committed to the database (MS Access
database). However, The changes are in the dataset.
Also, if I only change one record without subsequently moving to
another record, the HasChanges property of the DataSet is False. Moving
to another record before pressing the Update button fixes the problem.
Finally, as a piece of extra info, say that I change two records in the
dataset but I don't select a third one before clicking the Update
button, only commits to the database the first change.
Can anyone help me with this? I reckon that it is something rather
simple that is slipping my mind but I don't know what.
Thanks in advance,
Lefteris
Jim Hughes - 04 May 2006 01:41 GMT
Call EndEdit prior to Update
> Hi,
>
[quoted text clipped - 26 lines]
>
> Lefteris
Lefteris Kororos - 04 May 2006 01:56 GMT
Thanks, that worked nicely!